Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JNotenboom
Starting Member
27 Posts |
 Posted - 2001-06-28 : 10:54:03
|
| Hello,Is it possible to retrieve fields from a certain table AND to get an OUTPUT variable at the same time by calling a stored procedure once?for example, the sp contains:select name, surename from tblUserand a outputvariable (for example an amount):@amount = 1200In my asp page, I want to get these three fields. Can I do it like this:Set conDB = server.createObject("blabla")strSQL = sp_johanSet rstGet = conDB.Execute(strSQL)rstGet.Fields("name")rstGet.Fields("surename")rstGet.Fields("amount")Can anybody help me? thanx in advance! |
|
|
|
|
|
retrieving values from sp by ASP page