Yep, no problem:

I created the usual insert sql statement to insert all of the updated rows back into the DB.

Next i created a dupcheck select statement which basically is a select statement...

What you need to do is loop over each value and do an update sql statement to insert a flag to say that you have emailed the player.
You will also need to concatenate a number against the form input...

Managed to figure out how to do this.

If anyones interested then let me know.

What about converting the Excel file to xml and then reading that in instead of the native xls format?

Just a thought.

JM

Hi all,

I have a good one here and i am hoping there is an answer for this.

I have a form which displays a profile. Each profile has multiple rows of data, each row consists of a sort order, an...

Hi arrgh,

I have come across a little problem.

I use query of quries to get the desired output, what i am struglling right now is qofq does not support outer joins.

Any ideas on how i can...

Yep,

You can always see whats in the URL scope by cfdumping it like so:

<cfoutput><cfdump var="#URL#"></cfoutput>

on the target page.

You can check to see whats in the URL.sitename...

Hi arrgh

Yes that looks like it will work.

The number of values is dynamic but i think i can take care of that.

I will try this out and let you know how it goes.

Many thanks for your help...

Hi arrgh,

Ok i am liking the idea, just struggling on how to impliment.

You say a lookup table which holds the positions. can you expand a little more on that approach please?

I understand...

Yes good question,

Let me explain further:
I didnt add that there is a sort order for each value and a grouping order.
The output from the query without doing the xml output is this:
...

Hello,

How can i produce the following output from a query:

<group1>
<value="100"> <-- This value is in a table
<value=""> <--The null ones are not in a table
<value="">
<value="">

Hi,

You may be better off using the bind attribute to link multiple selects together.

Have a look at Ben Fortas example using linked selects
url:...

Hi me again,

Alternativly why not change your wysiwyg editor to this one:
open wysiwyg editor.
url: http://www.openwebware.com/

There is a third party spell checketr available for $8.

Not...

Hi ,

Have you tried JSpell?

URL is:
http://www.thesolutioncafe.com/fckeditorspellchecker.html

rgds

JM

Hi,

What happens if you dont put the mask in?

Does it still display 12AM?

JM

Hi,

If you stopped the page from refreshing how would it get the results in the first place? i don't really understand your question?

You would be better off creating methods in cfc's for your...

Hi,

To enable session variables on your pages you need to define the following at the top of each page:

<cfapplication name="Your application Name"
sessionmanagement="Yes"...

I managed to get this to work by creating two views.
One for the failed qty table and one for the passed qty table.
Each view summed the failed and passed qtys and i then joined both tables using...

Hi all,
I have a bit of an issue with an application that i am currently developing.
The application logs passed and failure information for a production line.
Each production lineis broken down...

Name: Matt
Nickname: jedimatt
Height: 6'
Weight: 173
Hair: Brown
Eyes: Brown
Location: UK
Hobbies: Life

Fav Music: U2, SimpleMinds, Coldplay