Oh, I thought u said you wanted to use an IN statement, which is of course a list.
> -----Original Message----- > From: Paul Johnston [mailto:[EMAIL PROTECTED]] > Sent: 15 January 2003 11:33 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL question > > > > 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] > > -- ** 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]
