Yea, it's something I've struggled with for a while -- I guess I've never really understood why afaik no one's ever introduced native support for lists in the rdbms as a parameter for a stored procedure.
> 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
