> If it's a list, you do not want an INT, you want a VARCHAR.
> So declare it is a varchar in the SP.
?????
CF:
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="#mylist#">
SP:
CREATE PROCEDURE blah
@lstblah varchar(1000)
AS...
?????
The question was how to create a list of "int"s from a "varchar" input to a
stored procedure using SQL.
Paul
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
