Stored Proc Output Parameter problem

[gus121]

Hi i have a stored proc which has three Sql queies in it.
2 of the queries i am outputing as output parameters. The third query i output as a recordset.

I am having trouble because i have circumstance where the result of one or more query brings back no result sets.

This appears to result in the failure to retrieve any data from the query to my ASP web application. Is this what i should expect?

Do i have to seperate these queries into seperate stored procs and run them indiviually?

I seem to be able to 'Exec' the stored proc ok but this does not display the results of the output parameters instead just displays the recordset how do i display the results of the output parameters?


thanks for your time


-Gus

 

[vongrunt]

OUTPUT parameters are not displayed like recordsets. They are passed by reference (sort of) to caller @variables. So you can use additional PRINT/SELECT on these variables for debug purposes.

Why procedure sometimes doesn't bring results back... post code here.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)