Neil, There are a few ways to deal with this. Here's one option.
http://accesshelp.net/content/Report.asp?REPORT=4&PARAM_ID=46 Chris -----Original Message----- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 2:07 PM To: CF-Talk Subject: Re: Stored Proc list input Impossible that there is no way to do this, at least you would think so?! Neil ----- Original Message ----- From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 1:52 PM Subject: Re: Stored Proc list input > Likely you're going to run into a larger issue with your database not being > able to interpret the @PassVariable value as an integer... at least with MS > SQL Server I have yet to find a way to pass a list to a stored procedure > without passing it as a varchar and then using exec (@mysqlstatement) or > exec sp_executesql @mysqlstatement which somewhat defeats the purpose of the > storedprocedure being pre-processed. > > > 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 > > S. Isaac Dealey > Certified Advanced ColdFusion 5 Developer > > www.turnkey.to > 954-776-0046 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
