Nope, you don't need the quotes at all, because QuotedValueList() will put them in for you. Adding them manually will cause an error.
> -----Original Message----- > From: Janine Jakim [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 12:13 PM > To: CF-Talk > Subject: RE: SQL IN command > > > That depends- is it a number field or a character field? > Number=no > varchar=yes. > > -----Original Message----- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 3:10 PM > To: CF-Talk > Subject: SQL IN command > > > Is it necessary to wrap the variable ProductsFound which is a list of ID > numbers in single quotes? > > <CFSET ProductsFound = QuotedValueList(qProducts.product_id)> > <CFQUERY name="qRemoveProducts" datasource="dsn"> > DELETE FROM tbl_products > WHERE product_id IN ('#ProductsFound#') > </CFQUERY> > > Regards, > > Dave Bosky > Sr. Multimedia Web Designer > Horry Telephone Cooperative, Inc. > office: (843)369-8613 > [EMAIL PROTECTED] > > > > HTC Disclaimer: The information contained in this message may be > privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
