Try
WHERE ItemName IN (#ItemNames#)
Dick
At 9:54 AM -0500 12/20/00, Perez, Bismark wrote:
>Hello list,
>
>I have a problem I can't see to find the answer... I have a list field I
>want to use as a retrieval argument of a query, but some how the database
>don't like the way I'm defining the retrieval... for the life of me I can't
>see where the error is, maybe you guys can help... the following is an
>example of the code
>
><cfset ItemNames = "'Item1','Item2','Item34'">
>
><cfquery ....
> SELECT ItemID, Description FROM Items
> WHERE ItemName IN '(#ItemNames#)'
></cfquery...
>
>I have tried to even include the parenthesis in the ItemNames field with not
>luck... if I use the statement on an interactive SQL it returns records so I
>know the statement works...
>
>Bismarck Perez
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
