Monday, December 03, 2007

Classic ASP: MARS

I've cleaning up a bunch of classic ASP code and basically I'm taking about 10 stored procs that execute in sequence on a page and just creating one uber stored proc that brings back multiple records sets (I didn't write the first version of the page). For future reference, since I always forget this, the syntax is...

Set myrecordsetobj=myrecordsetobj.NextRecordset()

No special stuff needed on the stored proc's end, just use multiple selects.

No comments: