Serves me right for not double checking the docs before posting. Matt Osbun Applications Manager Health Systems, International
-----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 8:43 AM To: CF-Talk Subject: Re: problem using a text list variable in a query statement On 9/29/05, Matt Osbun <[EMAIL PROTECTED]> wrote: > Delete from optomSitePhotos > WHERE photoLocation IN (<cfqueryparam value="#qualDelPhotoList#">) > > Ought to do the trick. It will, if you add the list="yes" attribute to the <cfqueryparam> tag. -- Charlie Griefer CONFIDENTIALITY NOTICE: The information contained in this transmission, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited by Federal law. If you are not the intended recipient of this message, you are notified that you may not disclose, print, copy, or disseminate this information. If you have received this transmission in error, please reply to the sender and delete or destroy the message. Unauthorized interception of this transmission may be a violation of criminal law. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
