Fejl hjælp
Her er koden:<html>
<head><title><% Response.Write Request.Querystring(\"id\") %> </title>
</head>
<body bgcolor=\"#000000\" text=\"#808080\" link=\"#808080\" vlink=\"#808080\" alink=\"#808080\">
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
DSN = \"DRIVER={Microsoft Access Driver (*.mdb)};\"
DSN = DSN & \"DBQ=\" & Server.MapPath(\"databaser/info.mdb\")
Conn.Open DSN
strSQL = \"Select * From Order By By Desc\"
Set rs = Conn.Execute(strSQL)
Do
strId = rs(\"id\")
strDato = rs(\"dato\")
strFraklokken = rs(\"fraklokken\")
strPris = rs(\"Pris\")
strKost = rs(\"kost\")
strBy = rs(\"By\")
strSted = rs(\"sted\")
StrMiniinfo = rs(\"miniinfo\")
StrHeleinfo= rs(\"heleinfo\")
With Response
.Write \"<table border=\"\"1\"\" width=\"\"421\"\" height=\"\"32\"\" bgcolor=\"\"#33CCFF\"\">\"
.Write \"</tr>\"
.Write \"<td height=\"\"24\"\" bordercolor=\"\"#33CCFF\"\" bgcolor=\"\"#33CCFF\"\" width=\"\"8\"\" align=\"\"center\"\"></td>\"
.Write \"<td height=\"\"44\"\" bgcolor=\"\"#33CCFF\"\" bordercolor=\"\"#33CCFF\"\" bordercolorlight=\"\"#33CCFF\"\" bordercolordark=\"\"#33CCFF\"\" width=\"\"458\"\" align=\"\"center\"\"> \"
.Write strBy
.Write strId
.Write \"<table>\"
.Write \"<td width=\"\"2\"\" height=\"\"26\"\" rowspan=\"\"4\"\" bgcolor=#\"\"33CCFF\"\" bordercolor=\"\"#33CCFF\"\" bordercolorlight=\"\"#33CCFF\"\" bordercolordark=\"\"#33CCFF\"\"> </td>\"
.Write \"</tr>\"
.Write \"<tr>\"
.Write \"<td width=\"\"8\"\" height=\"\"19\"\" bordercolor=\"\"#33CCFF\"\" bgcolor=\"\"#33CCFF\"\" align=\"\"center\"\"> </td>\"
.Write \"<td width=\"\"458\"\" height=\"\"1\"\" bordercolor=\"\"#33CCFF\"\" bgcolor=\"\"black\"\" bordercolorlight=\"\"#33CCFF\"\" bordercolordark=\"\"#33CCFF\"\" rowspan=\"\"2\"\" align=\"\"center\"\"></td>\"
.Write \" \"
.Write \"</td>\"
.Write \"</tr>\"
.Write \"<tr>\"
.Write \"<td width=\"\"8\"\" height=\"\"1\"\" bordercolor=\"\"#33CCFF\"\" bgcolor=\"\"#33CCFF\"\" align=\"\"center\"\"> </td>\"
.Write \"</tr>\"
.Write \"<tr>\"
.Write \"<td width=\"\"8\"\" height=\"\"1\"\" bordercolor=\"\"#33CCFF\"\" bgcolor=\"\"#33CCFF\"\" align=\"\"center\"\"> </td>\"
.Write \"<p><td height=\"\"1\"\" bgcolor=\"\"#33CCFF\"\" bordercolor=\"\"#33CCFF\"\" bordercolorlight=\"\"#33CCFF\"\" bordercolordark=\"\"#33CCFF\"\" width=\"\"458\"\" align=\"\"center\"\">\"
.Write \"<a href=\'mereinfo.asp?id=\" & rs(\"id\") & \"\'>Jylland</a>\"
.Write \"</table>\"
.Write \"<p></tr><p>\"
.Write \"<p><p><p><p><p>\"
end with
rs.MoveNext
Loop While Not rs.EOF
Conn.Close
Set Conn = Nothing
%>
</body>
</html>
Når jeg tester den kommer dette:
Microsoft OLE DB Provider for ODBC Drivers fejl \'80040e14\'
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i FROM-delsætningen.
/liverollespil.dk/asp/landsdel.asp, linje 12
Men linje 12 er den her:
Set rs = Conn.Execute(strSQL) Hjælp!!
