%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <%Response.CodePage = 65001%>
<% response.buffer=true PRODUCT_TYPE=request.querystring("TIP") Set DBcon = Server.CreateObject("ADODB.Connection") DBcon.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("products.mdb")) SQLQuery = "SELECT * FROM Table1 WHERE PType='" & PRODUCT_TYPE & "'" Set RecSet = DBcon.Execute(SQLQuery) %>
<% DBcon.close set DBcon = nothing %>