hent fra database
Hej jeg har denne side der henter fra en database:<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Ny side 1</title>
</head>
<body>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("scart.mdb")
SQLstmt = "SELECT * FROM products WEHERE ccategory = " & Request("id") ORDER BY cname;"
'
'response.write SQLstmt
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%>
<table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#DDDDDD">
<tr>
<td width="100%" bgcolor="#3366CC" background="bag2.jpg"><b><font color="#FFFFFF" face="Verdana" size="2"><%= rsprod("cname") %></font></b></td>
<td width="100%" bgcolor="#3366CC" background="bag2.jpg"> </td>
</tr>
<tr>
<td width="100%" valign="top"><font face="Verdana" size="2">
<%= rsprod("cdescription") %><br>
</font>
</td>
<td width="100%" valign="top">
<br>
<font face="Verdana" size="2"><img src="<%= rsprod("cimageurl") %>" align="right"></font></td>
</tr>
<tr>
<td width="100%" valign="middle"><form action="addprod.asp" method="POST">
<p><font face="Verdana" size="2"><b>Pris:</b> <%= FormatCurrency(rsprod("cprice"),2)%><b>
Antal:</b>
<input maxLength="1" name="fquantity" size="2" value="1"> </font> <strong> <font face="Verdana" size="2"> <input type="submit" value="Tilføj" name="order" style="font-family: Verdana; font-size: 10 pt; background-color: #3366CC; background-image: url('file:///D:/Inetpub/wwwroot/bag2.jpg'); color: #FFFFFF; border-style: outset"></font></p>
<font face="Verdana" size="2">
<input type="hidden" name="fproductid" value="<%= rsprod("catalogID")%>"> </font> </form>
</strong>
</td>
<td width="100%" valign="top">
</td>
</tr>
</table>
<br>
<%
rs.MoveNext
LOOP
RS.Close
Response.Write "</TABLE>"
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>
</body>
</html>
Jeg har leget lidt med det, men jeg får bare fejlen: Der opstod intern HTTP 500 serverfejl.... Der det mit script eller serveren?
Hvis det er scriptet, så er det meningen det skal hente produkterne fra en database ned og sortere dem efter kategori og derefrer navn..
