Would you happen to have any more details? Nothing I have found mentions it.
Neil ----- Original Message ----- From: "Adrian Lynch" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 1:25 PM Subject: RE: Stored Proc list input > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
