[thelist] ASP - Creating Multiple Recordsets - How Do I?

[Dru and Cindy Sellers]

I am trying to use ASP to write multiple recordsets for me. This is my first
time so I hope my code goes through ok.

<% Set rsCat = CONNECTION.execute("SELECT * FROM Cat") %>

<%
multiSQL = "Set rsSubSector" & rsCat(\"SectorID\") & "=
CONNECTION.execute(\"SELECT * FROM SubCat WHERE Cat=" & rsCat(\"SectorID\")
\")
rsCat.movenext

do until rsCat.EOF
	multiSQL = multiSQL & vbcrlf & vbcrlf
	multiSQL = "Set rsSubSector" & rsCat(\"SectorID\") & "=
CONNECTION.execute(\"SELECT * FROM SubCat WHERE Cat=" & rsCat(\"SectorID\")
\")
	rsCat.movenext
	repeat loop
loop %>

<% multiSQL %>

if you can help me in any way I would greatly appriciate it.

dRu
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.386 / Virus Database: 218 - Release Date: 9/9/02