Paging
jeg har en kode her, som der kun skal indsættes 9 \"objekter\" fra db\'enl, men jeg kan ikke få det til at virke, så jeg vil gerne ha lavet hele koden og jeg vil ikke hav denne link http://www.activeserverpages.dk/aspdigital/kapitel2/paging.asp jeg vil ha lavet hele koden så det virker!her er så koden:
<%
response.buffer = true
action = request(\"action\")
step = request(\"step\")
set conn = Server.CreateObject(\"ADODB.Connection\")
conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")
%>
<html>
<head>
<title>Send en gave</title>
</head>
<body>
<b><u>Send gave</u></b><p>
<% if step = \"\" and action = \"\" Then
if session(\"kategori\") = \"\" Then
session(\"kategori\") = \"1\"
end if
SQL = \"select top 12 * from gaver where\"
if session(\"kategori\") <> \"\" Then
SQL = SQL & \" anledning =\" & session(\"kategori\")
end if
if session(\"alder\") <> \"\" Then
SQL = SQL & \" and alder =\" & session(\"alder\")
end if
if session(\"prisleje\") <> \"\" then
SQL = SQL & \" and prisleje =\" & session(\"kategori\")
end if
set rs = conn.execute( SQL )
%>
<form action=\"velgvare.asp?step=1\" method=\"post\">
<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"100%\">
<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"25%\">Kategori:
<select name=\"kategori\">
<option <% if session(\"kategori\") = \"0\" Then %>selected <%end if %>value=\"0\">Undskyldninger</option>
<option <% if session(\"kategori\") = \"1\" Then %>selected <%end if %>value=\"1\">Kærlighed</option>
<option <% if session(\"kategori\") = \"2\" Then %>selected <%end if %>value=\"2\">Ferie</option>
<option <% if session(\"kategori\") = \"3\" Then %>selected <%end if %>value=\"3\">Fødsel</option>
<option <% if session(\"kategori\") = \"4\" Then %>selected <%end if %>value=\"4\">Bryllup</option>
<option <% if session(\"kategori\") = \"5\" Then %>selected <%end if %>value=\"5\">Eksamenstid</option>
<option <% if session(\"kategori\") = \"6\" Then %>selected <%end if %>value=\"6\">Højtider</option>
<option <% if session(\"kategori\") = \"7\" Then %>selected <%end if %>value=\"7\">Jul</option>
<option <% if session(\"kategori\") = \"8\" Then %>selected <%end if %>value=\"8\">Påske</option>
<option <% if session(\"kategori\") = \"9\" Then %>selected <%end if %>value=\"9\">Valentins
dag</option>
<option <% if session(\"kategori\") = \"10\" Then %>selected <%end if %>value=\"10\">Mors
dag</option>
<option <% if session(\"kategori\") = \"11\" Then %>selected <%end if %>value=\"11\">Fars
dag</option>
<option <% if session(\"kategori\") = \"12\" Then %>selected <%end if %>value=\"12\">Ferie</option>
<option <% if session(\"kategori\") = \"13\" Then %>selected <%end if %>value=\"13\">Sommer
og sol</option>
</select>
</td>
<td width=\"25%\">Alder:
<select name=\"alder\">
<option <% if session(\"alder\") = \"0\" Then %>selected <%end if %>value=\"0\">0-5</option>
<option <% if session(\"alder\") = \"1\" Then %>selected <%end if %>value=\"1\">5-10</option>
<option <% if session(\"alder\") = \"2\" Then %>selected <%end if %>value=\"2\">10-15</option>
<option <% if session(\"alder\") = \"3\" Then %>selected <%end if %>value=\"3\">15-20</option>
<option <% if session(\"alder\") = \"4\" Then %>selected <%end if %>value=\"4\">20-25</option>
<option <% if session(\"alder\") = \"5\" Then %>selected <%end if %>value=\"5\">25-30</option>
<option <% if session(\"alder\") = \"6\" Then %>selected <%end if %>value=\"6\">30-35</option>
<option <% if session(\"alder\") = \"7\" Then %>selected <%end if %>value=\"7\">25-40</option>
<option <% if session(\"alder\") = \"8\" Then %>selected <%end if %>value=\"8\">40-50</option>
<option <% if session(\"alder\") = \"9\" Then %>selected <%end if %>value=\"9\">50-60</option>
<option <% if session(\"alder\") = \"10\" Then %>selected <%end if %>value=\"10\">60-70</option>
</select>
</td>
<td width=\"25%\">Pris leje:
<select name=\"prisleje\">
<option <% if session(\"prisleje\") = \"0\" Then %>selected <%end if %>value=\"0\">10-20</option>
<option <% if session(\"prisleje\") = \"1\" Then %>selected <%end if %>value=\"1\">25-40</option>
<option <% if session(\"prisleje\") = \"2\" Then %>selected <%end if %>value=\"2\">50-100</option>
<option <% if session(\"prisleje\") = \"3\" Then %>selected <%end if %>value=\"3\">200-300</option>
<option <% if session(\"prisleje\") = \"4\" Then %>selected <%end if %>value=\"4\">500-1000</option>
<option <% if session(\"prisleje\") = \"5\" Then %>selected <%end if %>value=\"5\">1000à</option>
</select>
</td><td><input type=\"submit\" value=\"Videre\"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=\"100%\">
<% if step =\"\" then %>
<br><center>
<%
taller = 0
strSQL = \"Select * From gaver ORDER BY kategori\"
set rs = Conn.execute(strSQL)
%>
<%
IF rs.EOF then
%>
Ingen Gaver Fundet :o(
<%
else
%>
<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td bgcolor=\"#C0C0C0\"><center><b>Gaver:</b></center></td>
</tr>
<tr>
<td width=\"100%\">
<div align=\"center\">
<center>
<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<%
counter=0
Do While Not rs.EOF
if counter=0 then
Response.Write \"<tr>\"
end if
%>
<td>
<img src=\"gaver/<%=rs(\"url\")%>\"><br>
Gavenavn: <%=rs(\"gave\")%><br>
Alder: <%=rs(\"alder\")%><br>
Pris: <%=rs(\"pris\")%><br>
<input type=\"checkbox\" name=\"<%=rs(\"id\")%>\" value=\"1\" <%if session(\"gave\" & rs(\"id\")) <> \"\" Then %>checked<% end if %>>
</td>
<%
counter=counter+1
if counter = 2 then
counter=0
Response.Write \"</tr>\"
end if
%>
<%
rs.movenext
loop
end if
rs.close
set rs = nothing
%>
</tr>
</table></center>
<p> <a href=\"velgvare.asp?step=2\">Send gaver</a>
</form>
<%
end if
%>
