The reason I've tried to avoid doing this in the past is because ms sql server loops are slow ( funny that, considering how quickly it deals with record sets )... not to mention it's a lot more code in the sp where there aren't any native list functions -- or you have to build your own sql server udf's for ms sql 2000... just my 2c...
> 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 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
