Dave:
The list, regardless of datatype, should never be enclosed in quotes.
However, if the list contains character values, than each value should be
enclosed in single quotes. For example:
Numeric - ... IN (1,2,3,4,5)
Text - ... IN ('a','b','c','d')
HTH
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -----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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
