Hvad er der i vejen med det her script?
Jeg er ret sikker på at det er i htm-delen fejlen findes, da det virkede fint indtil jeg begyndte at rode rundt i selve visningen i htm visningen:<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<% Response.Buffer = true %>
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<title>Sgning skal kun komme frem n gang</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<%
// Henter vrdien fra soeg.htm
strKeyword = String(Request.Form("Keyword"));
if(strKeyword.length==0){
// Hvis der ikke er skrevet i feltet
Response.Redirect("search.htm");
}
else{
// Hvis der er skrevet i feltet
strKeyword = strKeyword.replace(/'/i,"''")
}
// Opbygger en dynamisk SQL streng
strSQL = "SELECT ingrediens, dansk, tysk, navn, beskrivelse FROM make_data WHERE ingrediens LIKE '%" + strKeyword + "%' OR dansk LIKE '%" + strKeyword + "%' OR tysk LIKE '%" + strKeyword + "%' ORDER BY ingrediens ASC";
// Skaber DSNLess forbindelse til DBen
myConn = Server.CreateObject("ADODB.Connection");
DBPath = "DBQ=" + Server.mappath("INCI.mdb");
myConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; " + DBPath);
// Skaber et recordset udfra SQL strengen
rs = myConn.Execute(strSQL);
looptroop="";
Response.Write("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"56%\" id=\"AutoNumber1\" height=\"215\">");
if(!rs.BOF&&!rs.EOF){
// Hvis der er fundet poster p sgningen
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"8%\"></td>");
Response.Write(" <td width=\"42%\">");
Response.Write(" <p align=\"left\">");
Response.Write(" <b>");
Response.Write(" <font size=4>Resultat af sgning</font></b></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"></td>");
Response.Write(" <td width=\"56%\"></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
while(!rs.EOF){
if(looptroop!=rs.Fields("ingrediens")){
looptroop=rs.Fields("ingrediens")+"";
funk="Funktion:"
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"><b><font size=\"2\">Ingrediens:</font></b></td>");
Response.Write(" <td width=\"56%\"><b><font size=\"2\">" + rs.Fields("ingrediens") + "</font></b></td>");
Response.Write(" <td width="25%"></td>");
Response.Write(" </tr>");
if(rs.Fields("dansk")!=""&&String(rs.Fields("dansk"))!="null"){
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"></td>");
Response.Write(" <td width=\"56%\"></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"><b><font size=\"2\">Dansk navn:</font></b></td>");
Response.Write(" <td width=\"56%\"><i><font size=\"2\">" + rs.Fields("dansk") + "</font></i><font size=\"2\">");
Response.Write(" </font></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
}
if(rs.Fields("tysk")!=""&&String(rs.Fields("tysk"))!="null"){
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"></td>");
Response.Write(" <td width=\"56%\"></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"><b><font size=\"2\">Tysk navn: </font> </b></td>");
Response.Write(" <td width=\"56%\"><i><font size=\"2\">" + rs.Fields("tysk") + "</font></i><font size=\"2\">");
Response.Write(" </font></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"></td>");
Response.Write(" <td width=\"56%\"></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
}
}
else{
funk=" "
}
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"><strong><font size=\"2\">"+funk+"</font></strong></td>");
Response.Write(" <td width=\"56%\"><b><font size=\"2\">" + rs.Fields("navn") + "</font></b></td>");
Response.Write(" <td width="25%"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"></td>");
Response.Write(" <td width=\"56%\"><font size=\"2\">" + rs.Fields("beskrivelse") + "</li></font></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"></td>");
Response.Write(" <td width=\"56%\"></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"1%\"></td>");
Response.Write(" <td width=\"56%\"><b><a href=\"http://a.domaindlx.com/Hejsa/inci.htm\">");
Response.Write(" <font size=\"2\">Tilbage til sgning</font></a></b></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write("</table>");
Response.Write("<p></p>");
rs.MoveNext();
}
}
else{
// Hvis der ikke er fundet poster p sgningen
Response.Write("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"56%\" id=\"AutoNumber1\" height=\"215\">");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"50%\"><font size=\"2\" face="Times New Roman"><b>strKeyword = ");
Response.Write(" String(Request.Form("Keyword")); </b>er ikke fundet i databasen.</font></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"50%\"></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"50%\"><font size=\"2\" face=\"Times New Roman\">Vi gr opmrksom p, at listen der sges p ikke er udtmmende, idet ingredienser lbende kommer p listen. Listen opdateres en gang hvert 1 - 2 r. vis</font><span style=\"font-size: 10pt; font-family: Times New Roman\">");
Response.Write(" der skulle vre enkelte ingredienser der ikke er at finde i sgningen, bedes man kontakte <ahref="http://www.colipa.org">COLIPA</a>, der er den europiske brancheorganisation for kosmetiske produkter, og som str for navngivningen i forhold til INCI-nomenklaturen.</span></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"50%\"></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write(" <tr>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" <td width=\"50%\">");
Response.Write(" <p align=\"center\"><b><a href=\"http://a.domaindlx.com/Hejsa/inci.htm\">");
Response.Write(" <font size=\"2\">Tilbage til sgning</font></a></b></td>");
Response.Write(" <td width=\"25%\"></td>");
Response.Write(" </tr>");
Response.Write("</table>");
}
Response.Write("</table>");
// Rydder op efter os
myConn.Close()
myConn = null;
%>
</body>
</html>
