[thelist] return a value from a stored proc

[Chris Blessing]

Hi all-

I've run into an issue that is very strange, to me at least.

What I'm doing is executing a stored procedure (SQL Server 7) from an ASP
page like this:

set rs = conn.execute("usp_myProc " & value)

The stored proc contains several insert statements.  At the end of the
stored proc I have:

select @aid

Which is supposed to return a value (identity value from one of the
inserts).  It prints the value just fine if I run this stored proc from
query analyzer, but if I use ado like I have above (set rs = ...) I get
nothing back!  So a test like:

if rs(0) <> "" then
	...
end if

Will result in the error:

ADO could not find the object in the collection corresponding to the name or
ordinal reference requested by the application.

Any tips?  Am I doing something wrong to get this value back?  I can't
figure out wtf is going on! =)

Thanks.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net