SQL Server Stored Procedure OUTPUT parameters

[sunny456]

I am calling a SQL Server stored procedure which has 1 input parameter and 3 output parameters. I can call the procedure and it runs successfully(I checked in the SQL debugger that all 3 outout parameters are populated correctly) but when I check the variables afterwards in Cold Fusion they all contain zeros?

Does anyone have any working example of calling a SQL Stored Proc and successfully getting back data in an output parameter?

Thanks in advance,

Sunny

 

[bhightower]

WHAT do you have so far......

------------------------------------------------------------------------------
brannonH
if( !succeed ) try( );