[thelist] ASP: Sub Recordsets?

Joshua Olson joshua at waetech.com
Mon Jul 14 11:24:16 CDT 2003

----- Original Message ----- 
From: "Casey Crookston" <casey at thecrookstons.com>
Sent: Monday, July 14, 2003 12:12 PM

> How in the name-of-the-sql gods does one build such a select statement?
> is it better to have three recordset objects each with their own select...
> one containing all jobs, one containing all categories, and one containing
> all formen.  The Jobs set loops once, and within each job loop the other
> both loop one time each, are rendered in the drop down list, and then
> back to BOF to get ready for the next loop.  Make sense?

Definitely create 3 recordsets.  You can use the method "MoveFirst" to reset
the recordset back to the first record.

Alternately, you could use GetRows and move the data from the recordsets
into arrays and then loop over the arrays at will.

Good luck,

Joshua Olson
Web Application Engineer
WAE Tech Inc.

More information about the thelist mailing list