>>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. 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
