[ cf-dev ] Spot the problem - IN()

[Dave Phipps]

Hi,

I am running into a problem with a query that is looking at a list to get the records for items in the list. I have three queries all running very similar code and the last query is not putting the comma in between the list items and therefore is returning no records.

The line of code is:

WHERE journoid IN (<cfloop index="d" list="#attributes.journoid#">'#d#'<cfif ListLast(attributes.journoid) NEQ d>, </cfif></cfloop>)

In the debug I see the two journoid values listed but without a comma separating them.

I have another query which uses this code:
WHERE journoNatOpt.natOptid IN(<cfloop index="c" list="#valuelist(storyNatOpt.natOptid)#">'#c#'<cfif ListLast(valuelist(storyNatOpt.natOptid)) NEQ c>, </cfif></cfloop>)

As you can see there is not a great deal of difference between the two lines except that the first one does not work.

Can anyone spot what I have missed?

Cheers

Dave


--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]