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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
