asp - sql - newbie question

[sezme]

i have created a recordset called rs

now i would like to use a value returned from this recordset to create another recordset

sql = "Select * from table where lID = "& rs("lID&quot

my question is this.

is this the right way to do this ? will i come across problems later on by creating a second recordset - the code I have written works - but i want to know what other people do.

thanks

sez

 

[100dtl]

You can create as many recordsets to the permitted amount.

sql =" select id from idtable where id ="&rs("id&quot
set rs2 = conn.execute(sql)
sql =" select id from idtable where id ="&rs2("id&quot
set rs3 = conn.execute(sql)
sql =" select id from idtable where id ="&rs3("id&quot
set rs4 = conn.execute(sql)
sql =" select id from idtable where id ="&rs4("id&quot
.....
I like to cast
sql =" select id from idtable where id ="&CInt(rs("id&quot)
set rs2 = conn.execute(sql)
sql =" select id from idtable where id ="&CInt(rs2("id&quot)
set rs3 = conn.execute(sql)
sql =" select id from idtable where id ="&CInt(rs3("id&quot)
set rs4 = conn.execute(sql)
sql =" select id from idtable where id ="&CInt(rs4("id&quot)