Actually, There is a function that is intended for this kind of situations:
ListQualify(listVar,"'") Pascal -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: maandag 17 december 2001 23:23 To: CF-Talk Subject: RE: IN condition... help? 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 ________________________________________________________________________________ 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