Hvorfor sorterer den ikke?
Har denne kode hvor man skal kunne sorterer efter hvilket link man trykker på. Men den sorterer aldrig, sql-stringen bliver udskrevet rigtigt.<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Rabetten Alla</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="jourblomman.css" rel="stylesheet" type="text/css">
</head>
<%
set conn = server.CreateObject("ADODB.CONNECTION")
DSN = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("jourblomman.mdb")
conn.Open DSN
strSQL = "SELECT * FROM rabatten ORDER by '"& request.querystring("val") &"'"
%>
<body>
<table width="800" border="0" cellspacing="2" cellpadding="0">
<tr align="left" valign="top">
<td><a href="rabatten_all.asp?val=name">NAMN</a></td>
<td><a href="rabatten_all.asp?val=birthday">FÖDELSEDAG</a></td>
<td><a href="rabatten_all.asp?val=address">ADRESS</a></td>
<td><a href="rabatten_all.asp?val=zipcode">POST NR</a></td>
<td><a href="rabatten_all.asp?val=city">ORT</a></td>
<td><a href="rabatten_all.asp?val=email">E-POST</a></td>
<td><a href="rabatten_all.asp?val=id">ID</a></td>
<td> </td>
</tr>
<tr align="left" valign="top" bgcolor="#CCCCCC">
<td colspan="8"><img src="bilder/1x1space.gif" width="1" height="1"></td>
</tr>
<%
set RS = conn.execute(strSQL)
while not rs.EOF
%>
<tr align="left" valign="top">
<td><%=rs("name")%></td>
<td><%=rs("birthday")%></td>
<td><%=rs("address")%></td>
<td><%=rs("zipcode")%></td>
<td><%=rs("city")%></td>
<td><%=rs("email")%></td>
<td><%=rs("id")%></td>
<td align="right"><a href="#">TA BORT</a></td>
</tr>
<tr align="left" valign="top" bgcolor="#CCCCCC">
<td colspan="8"><img src="bilder/1x1space.gif" width="1" height="1"></td>
</tr>
<%
rs.moveNext
Wend
Conn.Close
Set Conn = Nothing
response.write strSQL
%>
</table>
<br>
</body>
</html>
