pass table variable to stored procedure

[gareth7]

I'm using SQL server 2000 connected to CFMX 6.1.

SQL 2000 can use table variables, so I wondered if it is possible for cold fusion to pass or receive a table variable with a stored procedure.

If anyone knows if this is possible (and how to do it), please let me know.

Thanks

 

[philhege]

gareth7,

I'm not sure that you can pass a table variable, but you can certainly return one in the form of a recordset. That is, you'd have to select from the table variable so that the return is a recordset, not a variable. I don't think CF can handle the complex data type.

Sure would like to know if anyone can prove me wrong, though....

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....