<% Dim cat cat = TRIM(Request.QueryString("idno")) Set Conn = Server.CreateObject("ADODB.Connection") MdbFilePath = Server.MapPath("database/rest_house.mdb") Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";" set RS = Conn.Execute("SELECT * from RH Where DISTRICT = '"&cat&"' ") %>
|