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 |
|
JBelthoff
Posting Yak Master
173 Posts |
 Posted - 2001-07-29 : 16:45:11
|
Hi Again,Here is what I would like to do.Currently I have two stored procedures. One which gets all of the info to populate an HTML PullDown Field, and another to select which one the user has selected in that PullDown to mark as selected.Both of these stored procedures are called from ASP using the ADO Command object and the Getrows of the RecordSet Object to avoid cursors.However, this still relies on 2 database commands to execute both stored proc's.I would like to use one ASP ADO Command to retieve 2 RecordSets, unfortunatly I am unsure as to how to deal with these when they are returned to ASP.For one recordset its simple,Set objRS = objCmd.Execute(SQL)Is there a way to return 2 recordsets to an array such as using the "GetRows" with one stored procedure. This would eliminate one of my database calls from ASP.Any help would be appreciated.Thanks,JB Still a NewBie!  I forgot one more thing,The second RecordSet sometime may or may not have any records. In such a case the pulldown will be set to "Please Select One" or something like that.Edited by - JBelthoff on 07/29/2001 16:55:33 |
|
|
|
|
|
Multiple RS's, SP's, and ASP?