Søg efter FLERE Kriterier i ASP/ Access?
Jeg har disse to filer:INDEX.ASP
----------------------------------------------------------------
<html>
<title>Hente data fra database</title>
<head>
</head>
<body>
<p align="center"><table border="1" width="25%" height="25%" cellspacing="0" cellpadding="5" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td bgcolor="#C0C0C0"><font face="Arial" color="#FFFFFF"><b><p align="center">Vælg venligst DN:</b></td>
</tr>
<tr>
<td>
<p align="center">
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("data.mdb")
Conn.Open DSN
strSQL = "Select * from produkter"
Set rs = Conn.Execute(strSQL)
Do
strNavn = rs("DN")
strLink = "<a href='data.asp?DN=" & rs("DN") & "'>" & strNavn & "</a>"
response.Write strLink & "<br>"
rs.movenext
loop while NOT rs.EOF
Conn.Close
Set Conn = Nothing
%>
</font></b>
<p align="center">
</td>
</tr>
</table>
<b><font face="Arial" size="2">
</font></b>
<p>
</p>
<p align="center">
<b><font face="Arial" size="2">
<br>
<br>
<p align="center">
</font><table border="1" width="25%" height="25%" cellspacing="0" cellpadding="5" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td bgcolor="#C0C0C0"><b><font face="Arial" color="#FFFFFF">Her kan du vælge fra listen hvilken DN du vil se efter:</b></font></b><font face="Arial" size="2"></p></td>
</tr>
<tr>
<td>
<form method="post" action="formdata.asp">
<p align="center">
<font face="Arial">
<b>
<select size="1" name="DN">
<option value="100" selected>100</option>
<option value="200">200</option>
<option value="250">250</option>
<option value="300">300</option>
<option value="400">400</option>
<option value="500">500</option>
</select><font size="2"> </font>
<input type="submit"><font size="2"> </font></b></font>
</p>
</form>
</td>
</tr>
</table>
</font></b>
</body>
</html>
----------------------------------------------------------------
DATA.ASP
----------------------------------------------------------------
<html>
<title>HENTER VARENAVN database</title>
<head>
</head>
<body>
<dl>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("data.mdb")
Conn.Open DSN
strSQL = "Select * From produkter WHERE DN= " & Request.Querystring("DN")
Set rs = Conn.Execute(strSQL)
Do
strNavn = rs("Varenavn")
strLink = "<a href='varen.asp?ID=" & rs("ID") & "'>" & strNavn & "</a>"
response.Write "Type: " & strLink & "<br>"
rs.movenext
loop while NOT rs.EOF
conn.close
%>
</dl>
<p><a href="index.asp">Retur til DN listen</a></p>
</body>
</html>
----------------------------------------------------------------
Den søger på et kriterie der hedder "DN".... HVAD NU, hvis den eks skal have en valgbox MERE, hvor man kan vælge "TRTK" inden i og den så søger på alle dem der passer til det????
