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 CFPROCPARAM and in the SP as well but it keeps saying its an int which it isnt. And i'm forgetting how to fix!! thx When I came back from Korea, I had no money, no skills. Sure, I was good with a

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. Whats the best way to send 1,2,3,4,5,6,7 into a SP, its

RE: Sending a list into a Stored Proc

2003-06-04 Thread John Stanley
can you do this? cfquery name=whatever datasaource=whatever exec sp_whatever '1,2,3,4,5,6,7',other params /cfquery -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