Hello....



got a quick question.  when using stored procedures, is there some kind of 

rule against using more than one recordset using different stored 

procedures on the same page with the same connection??



thank you very much!

use the Command object to fire your stored procedures...  and you'll have no

problems retrieving two recordsets...  you could just pass the name and

parameters through the connection object as well, but if you wanted the

stored procedure to report something back, then you'll need to clearly

define the Command object for each stored proc.... oh, and you can use the

same connection object throughout.



My long-term advice is always experiment if you're not sure... then you've

taught yourself something you didn't know...



Good luck!





Cory Koski

Web Programmer

Wabang Creative Technology and TBSource.com

Brainbench e-certified Master ASP programmer

(xxx) xxx-xxxx  ext. 41





----- Original Message -----

From: "Christopher McBride" 

To: "ASP Databases" <asp_databases@p...>

Sent: Monday, August 14, 2000 8:10 PM

Subject: [asp_databases] arrrgghhh... quick question





> Hello....

>

> got a quick question.  when using stored procedures, is there some kind of

> rule against using more than one recordset using different stored

> procedures on the same page with the same connection??

>

> thank you very much!

>