% @LANGUAGE="VBSCRIPT"%> <% Dim objConn, rsLL, ID, rsLRT, rsSub Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../../private/links.mdb") 'objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("links.mdb") ID = Cint(Request.QueryString("ID")) SET rsCat = Server.CreateObject("ADODB.Recordset") rsCat.Open "SELECT * FROM subheads ORDER BY subHEADING ASC;", objConn If ID = 0 then If NOT rsCat.EOF then ID = rsCat("subID") End if ID = 1 End if SET rsLink = Server.CreateObject("ADODB.Recordset") rsLink.Open "SELECT * FROM names WHERE fldSUBHEAD="& ID &" ORDER BY fldNAME;", objConn %>