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"