no need to initiate a loop.
This is much faster...
WHERE item IN ('#replace(listVar,",","','","all")#')
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Jason Green [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 17, 2001 1:22 PM
To: CF-Talk
Subject: RE: IN condition... help?
then you need to loop through each one in the IN statment and put ' ' around
each item....
WHERE item IN (<CFLOOP LIST="#listVar#" INDEX="i">'#i#'<CFIF i IS NOT
ListGetAt(listVar,ListLen(listVar))>,</CFIF></CFLOOP>)
try that.
>From: Paul Ihrig <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: IN condition... help?
>Date: Mon, 17 Dec 2001 16:17:17 -0500
>
>is #rs_View.Project_Type_ID2# a coma list of numbers? if so, try not
>adding
>
>the ' around it in the IN statment....
>
>no, it is text
>like (0264,0039 SF,0258,0257)
>
>i have tried
>IS, LIKE, IN
>
>any other ideas.
>
>thanks
>
>
____________________________________________________________________________
____
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
________________________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
