I'm getting these values passed from an existing form. And they are passed as '1,2,3'. And treated as a nvarchar(100) when passed to the existing sp. I've got to handle these inside my UDF (unfortunately). Any ideas on how I can transform them to '1','2','3' from the string '1,2,3' that's passed?
Rich Kroll Application Developer -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 1:42 PM To: CF-Talk Subject: RE: SQL Passed Varchar list If you are using CF to pass in your list, you can use CFQUERYPARAM's LIST attribute. Otherwise, you need to have single quotes around each element such as: ('1','2','3') M!ke ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:226258 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
