Søge problem i Access!
Hvad kan fejlen være her :(<%@ Language=VBScript %>
<html>
<SCRIPT language=\"javascript\"><!--
function displayWindow(url, width, height)
{
var Win = window.open(url,\"displayWindow\",\'width=\' + width + \',height=\' + height + \',left=10,top=10,resizable=no,scrollbars=yes,menubar=no,status=no\' );
}
//--></SCRIPT>
<%
if not Request(\"omrade\") = \"Alle\" then
SQL = \" shopomrade LIKE \'%\" & Request(\"omrade\") & \"%\'\"
end if
if not SQL = \"\" then
tekst = \" AND\"
end if
if not Request(\"alder\") = \"Alle\" then
SQL = SQL & shopalder & \" shopalder LIKE \'%\" & Request(\"alder\") & \"%\'\"
end if
if not SQL = \"\" then
tekst = \" AND\"
end if
if not Request(\"type\") = \"Alle\" then
SQL = SQL & tekst & \" shoptype LIKE \'%\" & Request(\"type\") & \"%\'\"
end if
if not SQL = \"\" then
tekst = \" AND\"
end if
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"shopdb.mdb\")
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
SQL = \"Select * From shops WHERE \" & SQL
rs.Open SQL, Conn, 1
if (rs.BOF Or rs.EOF) then
%>
<head>
<title></title>
</head>
<body bgcolor=\"#688CA0\">
<font face=\"Verdana\" size=\"2\">Der er desværre ingen profil, der matcher din søgning.
Prøv at formindske dine krav.</font><br><b><br><font face=\"Verdana\"><a href=\"java script:history.go(-1);\"><<
Tilbage</a></font></b>
<p>
<img border=\"0\" src=\"images/linie.jpg\">
<font color=\"#800000\">ddddddddddddd<a href=\"java script:displayWindow(\'profil.asp?shop_id=<%=rs(\"shop_id\")%>\',450,450)\"><font color=\"#800000\" face=\"Verdana\" size=\"3\"><b><%=rs(\"shopname\")%></b>
</font>
<font color=\"#688CA0\" face=\"Verdana\" size=\"3\">
</font> </font><font color=\"#800000\">.</a></font><font face=\"Verdana\" size=\"2\" font color=\"#000000\"><br><%=left(rs(\"omshop\"),50)%>....</font>
<p><img border=\"0\" src=\"images/linie.jpg\"></p>
<font face=\"Verdana\" size=\"2\" font color=\"#000000\">
<%end if%>
</font>
<p></p>
<p></p>
<p> </p>
</body>
</html>
