Sending a list into a Stored Proc

2003-06-04 Thread William Wheatley
Ok having a brain fart. Whats the best way to send 1,2,3,4,5,6,7 into a SP, its a VARCHAR on the 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

Re: Sending a list into a Stored Proc

2003-06-04 Thread Michael Tangorre
I use varchar, works fine. - Original Message - From: "William Wheatley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 03, 2003 2:11 PM Subject: Sending a list into a Stored Proc > Ok having a brain fart. > > Wha

RE: Sending a list into a Stored Proc

2003-06-04 Thread John Stanley
can you do this? exec sp_whatever '1,2,3,4,5,6,7',other params -Original Message- From: William Wheatley [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 2:11 PM To: CF-Talk Subject: Sending a list into a Stored Proc Ok having a brain fart. Whats the best w