I think cfprocparam has a list attribute. Ade
-----Original Message----- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 18:21 To: CF-Talk Subject: Stored Proc list input I need to pass a string such as 1,2 in to a stored procedure. The variable is then used like this: Where MYVariable IN (@PassVariable) Now the problem is that MYVariable is an INT and I am passing in the @PassVariable as a string. I get this error: Syntax error converting the varchar value '1,2' to a column of data type int. I need to figure some way around this. Any ideas? Thanks, Neil ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
