Results 1 to 3 of 3
Thread: Reusing recordsets - newbie
Sep 24, 2002, 08:24 #1
- Join Date
- Jun 2000
- Texas, USA
- 0 Post(s)
- 0 Thread(s)
Reusing recordsets - newbie
I'm sending a query in the page and if there are no recordsets returned, then i need to immediately send another query and print those results.
here's my "non-working" code
[VBS]Set cn = server.CreateObject("ADODB.Connection")
cn.Open "Provider=SQLOLEDB; Data Source= SQLECM02; Initial Catalog= wwwapp; user id= ecm_user; Password = ecm_user"
Set rs = server.CreateObject("ADODB.Recordset")
rs.Open "Select url, fName, lName from users as u, role as r, security as s where u.ntID ='" & user & "' and u.roleid = r.roleid and s.securityLevelReq <= r.securitylevel and s.securityLevelReq > 0;", cn
if rs.BOF and rs.EOF Then
rs.Open "Select url from security where securitylevelreq = 0"