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 Get the mailserver that powers this list at http://www.coolfusion.com
