>>>Server I have yet to find a way to pass a list to a stored procedure
> I found this a couple of days back; haven't tried it yet. Found what? I'd love to see a url or such if you've got one. :) > Matthew P. Smith > Web Developer, Object Oriented > Naval Education & Training Professional > Development & Technology Center > (NETPDTC) > (850)452-1001 ext. 1245 > [EMAIL PROTECTED] >>>-----Original Message----- >>>From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] >>>Sent: Tuesday, November 19, 2002 12:52 PM >>>To: CF-Talk >>>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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
