Avatar billede tpiil Nybegynder
10. oktober 2000 - 23:41 Der er 3 kommentarer og
1 løsning

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
%>
Avatar billede tpiil Nybegynder
10. oktober 2000 - 23:53 #1
jeg er villig til at give 200 point for det hvis det er lavet inden kl. 00:30
Avatar billede keysersoze Ekspert
10. oktober 2000 - 23:56 #2
<%
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=\"20%\">
<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=\"20%\">
<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=\"20%\">
<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 width=\"15%\">
<input type=\"submit\" value=\"Videre\">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=\"100%\">
<%
IF rs.EOF then
else
do until rs.eof
%>
<%
rs.movenext
loop
end if
rs.close
set rs = nothing
%>
<%

intPage = Request(\"page\")
If isNumeric(intPage) = False Or intPage < 1 Then
  intPage = 1
End If

Set rs2 = Server.CreateObject(\"ADODB.RecordSet\")
strSQL = \"SELECT * FROM gaver\"
strDSN = \"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\"&Server.MapPath(\"database.mdb\")
rs2.Open strSQL, strDSN, 1
If Not (rs2.BOF Or rs2.EOF) Then
  rs2.PageSize = 9
  rs2.AbsolutePage = intPage
  intRecCount = rs2.PageSize
  intPageCount = rs2.PageCount
  Response.Write \"<p><br>Side \" & intPage & \" af \" & intPageCount & \"</b></p>\"

%>

<div align=\"center\">
  <center>
  <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">

<%

    counter=0   
  Do While Not rs2.EOF And intRecCount > 0
   
    if counter=0 then
    Response.Write \"<tr>\"
    end if
   
%>


      <td><img src=\"gaver/<%=rs2(\"over\")%><%=rs2(\"url\")%>\"><br><%=rs2(\"gave\")%><br><%=rs2(\"alder\")%><br><%=rs2(\"pris\")%><br><br><input type=\"checkbox\" name=\"<%=rs2(\"id\")%>\" value=\"1\" <%if session(\"gave\" & rs2(\"id\")) <> \"\" Then %>checked<% end if %>><br></td>





<%


counter=counter+1
      if counter = 3 then

        counter=0
Response.Write \"</tr>\"
      end if

     


%>









<%

  intRecCount = intRecCount - 1
  rs2.MoveNext
    Loop
End If
rs2.Close
Set rs2 = Nothing
    %>
    </tr>
  </table>
  </center>
</div><%
Response.Write \"<p><font face=\'Verdana\'>Gå til side \"
For intNum = 1 To intPageCount
  Response.Write \"<a href=velgvare.asp?page=\" & intNum & \"><font face=\'Verdana\'>\" & intNum & \"</a> \"
Next

Response.Write \"<p>\"
If Clng(intPage) > 1 Then
  Response.Write \"<font face=\'Verdana\'><a href=vindere.asp?page=\" & intPage - 1 & \">&lt;&lt;</a>\"
Else
  Response.Write \"&lt;&lt;\"
End If

Response.Write \"&nbsp;\"

If Clng(intPage) < Clng(intPageCount) Then
  Response.Write \"<a href=velgvare.asp?page=\" & intPage + 1 & \">&gt;&gt;</a> \"
Else
  Response.Write \"&gt;&gt;\"
End If




set conn = Server.CreateObject(\"ADODB.Connection\")
conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")

%>



<p> <a href=\"velgvare.asp?step=2\">Send gaver</a>
</form>
<% elseif step = \"1\" Then
session(\"kategori\") = request(\"kategori\")
session(\"alder\") = request(\"alder\")
session(\"prisleje\") = request(\"prisleje\")
SQL = \"select * from gaver\"
set rs = conn.execute( SQL )
if rs.eof then
else
do until rs.eof
if request(rs(\"id\")) <> \"\" Then
session(\"gave\" & rs(\"id\")) = rs(\"id\")
end if
rs.movenext
loop
end if
rs.close
set rs = nothing
set SQL = nothing
response.redirect(\"velgvare.asp\")
%>
<% elseif step = \"2\" Then
SQL = \"select * from gaver\"
set rs = conn.execute( SQL )
if rs.eof then
else
do until rs.eof
if session(\"gave\" & rs(\"id\")) <> \"\" Then
%>
<img src=\"gaver/<%=rs(\"over\")%><%=rs(\"url\")%>\">
<%
end if
rs.movenext
loop
end if
rs.close
set rs = nothing
set SQL = nothing
%>
<form action=\"velgvare.asp?step=3\" method=\"post\">
Alle gaver skal sendes til samme adresse <input type=\"radio\" name=\"modtager\" value=\"1\"><br>
Alle gaver skal sendes til forskellige adresser <input type=\"radio\" name=\"modtager\" value=\"2\"><br>
<input type=\"submit\" value=\"Videre\">
</form>
<% elseif step = \"3\" then
if session(\"brugernavn\") = \"\" or session(\"id\") = \"\" Then
%>
<form action=\"velgvare.asp?action=login&back=<%=request(\"modtager\")%>\" method=\"post\">
Brugernavn:<br>
<input type=\"text\" name=\"brugernavn\"><br>
Password:<br>
<input type=\"password\" name=\"password\"><br>
<input type=\"submit\" value=\"Login\">
</form>
<%
else
if request(\"modtager\") = \"1\" Then
response.redirect(\"velgvare.asp?step=4\")
elseif request(\"modtager\") = \"2\" Then
response.redirect(\"velgvare.asp?step=5\")
end if
end if
%>
<% elseif step = \"4\" then
%>
Du har valgt at sende de valgte gaver til samme adresse udfyld venligst nedenstående felter med *
<form action=\"velgvare.asp?action=send1\" method=\"post\">
Firma<br>
<input type=\"text\" name=\"firma\"><br>
Navn/att. Navn *<br>
<input type=\"text\" name=\"navn\"><br>
Efternavn *<br>
<input type=\"text\" name=\"efternavn\"><br>
Adresse *<br>
<input type=\"text\" name=\"adresse\"><br>
By *<br>
<input type=\"text\" name=\"by\"><br>
Post nr. *<br>
<input type=\"text\" name=\"postnr\"><br>
Indtast tekst til gavekort *:<br>
<textarea name=\"note\" cols=\"20\" rows=\"4\"></textarea><br>
Vælg gavepapir  *<br>
<select name=\"gavepapir\">
<option value=\"0\">Gavepapir</option>
</select><br>
Vælg Betalingsmåde  *<br>
<select name=\"payform\">
<option value=\"0\">Efterkrav</option>
<option value=\"1\">Giro</option>
<option value=\"2\">Forudbetaling</option>
</select><br>
<input type=\"submit\" value=\"Send\">
</form>
<%
elseif action = \"send1\" Then
session(\"gave\" & request(\"ses\")) = \"\"
SQL = \"select * from brugere where id =\" & session(\"id\")
set rs = conn.execute( SQL )
Set JMail = Server.CreateObject(\"JMail.SMTPMail\")

JMail.ServerAddress = \"vip.cybercity.dk\"

JMail.Sender = \"mail@web-sale.dk\"
JMail.Subject = \"Din ordre er modtaget\"

JMail.AddRecipient rs(\"email\")

JMail.Body = \"Din ordre er modtaget\"

JMail.Priority = 1

JMail.Execute
Set JMail = nothing
SQL2 = \"select * from priser where id =1\"
set rs2 = conn.execute( SQL2 )
Set JMail = Server.CreateObject(\"JMail.SMTPMail\")

JMail.ServerAddress = \"vip.cybercity.dk\"

JMail.Sender = \"mail@web-sale.dk\"
JMail.Subject = \"Din ordre er modtaget\"

JMail.AddRecipient rs2(\"email\")

JMail.Body = \"Ny ordre fra \" & rs(\"brugernavn\")

JMail.Priority = 1

JMail.Execute
rs.close
set rs = nothing
set SQL = nothing
rs2.close
set rs2 = nothing
set SQL2 = nothing
%>
Din ordre er afsendt!
<% elseif step = \"8\" then
%>
Du har valgt at sende de valgte gaver til forskelige adresser<p>
<%
for i = 1 to 20
if session(\"gave\" & i) <> \"\" Then
SQL = \"select * from gaver where id=\" & session(\"gave\" & i)
set rs = conn.execute( SQL )
%>
<a href=\"velgvare.asp?step=9&id=<%=rs(\"id\")%>&ses=<%=i%>\"><img src=\"gaver/<%=rs(\"over\")%><%=rs(\"url\")%>\"></a>
<%
rs.close
set rs = nothing
set SQL = nothing
end if
next
%>
<% elseif step = \"5\" Then
%>
Udfyld venligst nedenstående felter med *
<form action=\"velgvare.asp?action=send1&id=\" method=\"post\">
Firma<br>
<input type=\"text\" name=\"firma\"><br>
Navn/att. Navn *<br>
<input type=\"text\" name=\"navn\"><br>
Efternavn *<br>
<input type=\"text\" name=\"efternavn\"><br>
Adresse *<br>
<input type=\"text\" name=\"adresse\"><br>
By *<br>
<input type=\"text\" name=\"by\"><br>
Post nr. *<br>
<input type=\"text\" name=\"postnr\"><br>
Indtast tekst til gavekort *:<br>
<textarea name=\"note\" cols=\"20\" rows=\"4\"></textarea><br>
Vælg gavepapir  *<br>
<select name=\"gavepapir\">
<option value=\"0\">Gavepapir</option>
</select><br>
Vælg Betalingsmåde  *<br>
<select name=\"payform\">
<option value=\"0\">Efterkrav</option>
<option value=\"1\">Giro</option>
<option value=\"2\">Forudbetaling</option>
</select><br>
<input type=\"submit\" value=\"Send\">
</form>
<%
elseif action = \"login\" Then
set conn = Server.CreateObject(\"ADODB.Connection\")
conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")
set check = Server.CreateObject(\"ADODB.Recordset\")
check.Open \"SELECT * FROM brugere WHERE brugernavn=\'\" & trim(request(\"brugernavn\")) & \"\'\", conn, 1, 3

if check.RecordCount = 0 then
session(\"fejl\") = \"Ukendt bruger\"
response.redirect(\"velgvare.asp?action=fejl\")

elseif check(\"password\") = request(\"password\") Then
session(\"brugernavn\") = check(\"brugernavn\")
session(\"id\") = check(\"id\")
check.close
set check = nothing
conn.close
set conn = nothing
response.redirect(\"velgvare.asp?step=\" & request(\"back\"))
else
session(\"fejl\") = \"Forkert password\"
response.redirect(\"velgvare.asp?action=fejl\")
end if
%>
<% elseif action = \"fejl\" Then
%>
<font color=\"ff0000\"><%=session(\"fejl\")%></font>
<% elseif step = \"9\" Then%>
<% end if %>
</body>

<%
conn.close
set conn = nothing
%>
Avatar billede keysersoze Ekspert
10. oktober 2000 - 23:58 #3
hvis jeg gætter rigtigt, så skal de 9 \"objekter\" stå 3 på række...
Avatar billede tpiil Nybegynder
11. oktober 2000 - 00:03 #4
nej, der skulle kun være 2 men TAK!
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester