Returning a single variable from stored proc instead of recordset?

[jacktripper]

Its been a while since I used classic ASP. I'm trying to modify some old code someone else wrote.

The code calls a stored procedure which returns a recordset. I want to change it so that it returns a single string variable that is defined in the proc.

So, the proc has an OUTPUT value of a @ReturnMessage string. But, the ASP code is currently:

set conn = CreateObject("ADODB.Connection")
conn.open Application("DB_ConnectionString")
set rs = CreateObject("ADODB.Recordset")
rs.open vcSQL,conn,1,1

This doesn't seem to work if all I am returning is a string result. I just get a big error message. The proc itself seems to run if I execute it in SQL Server.

Is there classic ASP code that can expect the result as something other than a recordset?

This is probably really simple, but it's not coming to me.

 

[xwb]

Try

http://www.developerfusion.com/samplechapter/91/stored-procedures/4/

I think it is just

@ReturnMessage = rs.Fields.Item(1)