Steve, Thanks, that worked. Didn't know about the undocumented "list" attribute of cfqueryparam.
Thanks, Mark -----Original Message----- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006 10:59 AM To: CF-Talk Subject: Re: Query when using UUID This should be the easiest way: <cfquery name="qSelectedCases" datasource="#REQUEST.dsnSQL#"> SELECT P.caseID, P.twgCaseNumber FROM MyClient_Clients_Projects_List P WHERE P.caseID IN (<cfqueryparam value="#FORM.caseID#" cfsqltype="CF_SQL_VARCHAR" list="Yes">) ORDER BY P.twgCaseNumber ASC </cfquery> HTH, Steve Bryant 918-449-9440 Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ >I'm using a cross select control on a form page, so I can select many >twgCaseNumbers (varchar) at a time. This code works correctly in other >logic when I employ simple integers for the FORM.caseID. However, in >this scenario, I'm using UUID's as the FORM.caseID's. It breaks when >more than one UUID is in the FORM.caseID list. Is there any way to >solve it using UUID's as the values? > ><cfquery name="qSelectedCases" datasource="#REQUEST.dsnSQL#"> > SELECT P.caseID, P.twgCaseNumber > FROM MyClient_Clients_Projects_List P > WHERE P.caseID IN ('#FORM.caseID#') > ORDER BY P.twgCaseNumber ASC > </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
