> > What is the best way to pass a list of strings into a
> stored proc for
> > use with an IN operator.
>
> <cfquery>
> EXEC procname (<cfqueryparam ... list="true">) </cfquery>
>
> Jochem

Yes of course. :-)  But I was trying to figure out it is was possible to
use the cfstoredproc tag....
Since I can get it to work calling the SP using the cfquery tag instead
I am now just trying to understand why the function in SQL Server does
not work as intended. I am sure has to do with my mis-understandings of
the internal workings of SQL server and how it represents and uses
string, etc...

Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to