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>
<cfset VARIABLES.caseNumberSelectedValues =
ValueList(qSelectedCases.caseID)>
<cfset VARIABLES.caseNumberSelectedTitles =
ValueList(qSelectedCases.twgCaseNumber)>
Thanks,
Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:259297
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
