I have a problem how to retrive data from two table in an access database,
Menysite1.asp retrive field "category" from table "categories" and the links to menysite2.asp?category=<% =rs("category" %> menysite2 collects "manufacture" from table "categories" and links to menysite3.asp?<% =rs("category" %> AND Manufacture=<% =rs("manufacture" %> menysite3 collects "modell" from tabel "categories" and links to list.asp?<% =rs("category" %> AND Manufacture=<% =rs("manufacture" %> AND Modell=<% =rs("modell" the page list.asp should retrive data from an table called "products" and the fields "artnr" "item" "color" "price"
I have tried the following code but i dont works, could someone help me correct this i'll be wery happy. Please mail a.s.a.p :-)
Code/
<%
Modell=Request.Querystring("Modell"
Category=Request.Querystring("category"
Manufacture=Request.Querystring("manufacture&# 34
Set conn = Server.CreateObject("ADODB.Connection"
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("data/*.mdb"
SQL = "SELECT p.Id, p.Artno, p.Item, p.Price FROM Products p, Categories c WHERE p.Id = c.Id AND p.Id = '" & Request.QueryString("Modell" & "' AND c.category = '" & Request.QueryString("category" & "' AND c.manufacture = '" & Request.QueryString("manufacture" & "'"
set rs = Server.CreateObject("ADODB.Recordset"
rs.Open SQL, conn, 3, 3
%>