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.clear
rs.Open "Select url from security where securitylevelreq = 0"
end if


[/VBS]

please help.