[thelist] return a value from a stored proc
Chris Blessing
webguy at mail.rit.edu
Wed Mar 27 14:06:01 CST 2002
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
More information about the thelist
mailing list