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:259302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
