OK, now I'm confused - what's wrong with this?
Setting the list:
<cfquery name="palist">
SELECT pa_id, atty_id FROM atty_pa
WHERE pa_id = '#paname.pa_id#'
</cfquery>
<cfset pa_list = ValueList(palist.atty_id)>
In the Query:
<cfif IsDefined("pa_list") AND #pa_list# NEQ "">
or atty_id IN (<cfqueryparam value="#pa_list#"
cfsqltype="CF_SQL_VARCHAR">)
</cfif>
Error:
Throws error:
Syntax error converting the nvarchar value
'2748C114-BCD2-35D3-DD2AEF5A2BDBE016' to a column of data type int.
atty_id is a value type "nvarchar"
The values in the list started out as interger ID numbers - but once I
took over, I saw a *huge* problem with duplicate ID numbers - so I
switched to using UUID instead.
With that in mind, pa_list would be any combination look like:
"23, 56, 192,2748C114-BCD2-35D3-DD2AEF5A2BDBE016, 887"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196769
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
