Sortering af links
Jeg har denne lille gæstebog, men jeg skal sorterer e-mail alfabetisk...Men hvordan...
Skal jeg sorterer i selve databasen eller skal den have en sort()record ????
Nogle foreslag.......
(¤_¤)/mille
----------------------------------------
Const adOpenKeyset = 1
Const adLockOptimistic = 3
Session.LCID = 1030
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("vittighed.mdb") & ";UID=admin;PWD=;"
If Request.Form("Gem") <> "" Then
strNavn = Trim(Request.Form("Navn"))
strEmail = Trim(Request.Form("Email"))
strKommentar = Trim(Request.Form("Kommentar"))
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM Guestbook WHERE (ID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs("Navn") = strNavn
rs("Email") = strEmail
rs("Kommentar") = strKommentar
rs("Dato") = Now()
rs.Update
End If
rs.Close
Set rs = Nothing
End If
%>
<html>
<head>
<title>Vittigheder</title>
</head>
<body link="#0096CE" vlink="#0096CE" bgcolor="#FFFFFF" text="#000000">
<div align="center"><center>
<table border="0" width="90%" cellspacing="0" cellpadding="3"
style="border-left: 1px solid rgb(0,0,0); border-right: 1px solid rgb(0,0,0); border-top: 1px solid rgb(0,0,0); border-bottom: 2px solid rgb(0,0,0)">
<tr>
<td width="100%" bgcolor="#0096ce"><p align="center"><font face="verdana" size="4"
color="#FFFFFF"><strong>Vittigheder</strong></font></td>
</tr>
<tr align="center">
<td width="100%"><%
Select Case strMode
Case "add"
%>
<form method="POST" action="vittighed_copy(1).asp">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td valign="middle" align="left" colspan="2"><div align="center"><center><p><font
face="verdana" size="2"><strong><br>
</strong>Indtast venligst oplysningerne i følgende felter:<strong><br>
</strong></font></td>
</tr>
<tr align="center">
<td valign="middle" align="left"><div align="right"><p><strong><font face="verdana"
size="2">Navn</font></strong></td>
<td valign="middle" align="left"><input type="text" name="Navn" size="40" value="Anonym"></td>
</tr>
<tr align="center">
<td valign="middle" align="left"><div align="right"><p><strong><font face="verdana"
size="2">E-mail</font></strong></td>
<td valign="middle" align="left"><input type="text" name="Email" size="40" value="Anonym"></td>
</tr>
<tr align="center">
<td valign="top" align="left"><div align="right"><p><font face="verdana" size="2"><strong>Vittighed</strong></font></td>
<td valign="middle" align="left"><textarea rows="3" name="Kommentar" cols="40">Vittighed</textarea></td>
</tr>
<tr align="center">
<td valign="middle" align="left" colspan="2"><div align="center"><center><p><br>
<input type="submit" value="Tilføj vittighed" name="Gem"> <input type="button"
value="Slet alt" name="Annuller" onClick="java script:history.back();"></td>
</tr>
</table>
</form>
<%
Case Else
Set myConn = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT * FROM Guestbook ORDER BY Dato DESC;"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<table border=0 cellpadding=3 cellspacing=0>"
Do While Not rs.EOF
Response.Write "<tr bgcolor=#C0C0C0><td><font face=verdana size=2>" & rs("Dato") & "</td></tr>"
If rs("Email") <> "" Then
Response.Write "<tr><td><font face=verdana size=2><strong><a href=mailto:" & rs("Email") & ">" & rs("Navn") & "</a> Har tilføjet denne vittighed:</strong></td></tr>"
Else
Response.Write "<tr><td><font face=verdana size=2><strong>" & rs("Navn") & " Har tilføjet følgende vittighed:</strong></td></tr>"
End If
Response.Write "<tr><td><font face=verdana size=2>" & rs("Kommentar") & "<br> </td></tr>"
rs.MoveNext
Loop
Response.Write "</table>"
Else
Response.Write "<p><font face=verdana size=2>Der er endnu ikke nogle der har tilføjet nogen vittigheder</font></p>"
End If
myConn.Close
Set myConn = Nothing
Response.Write "<p><a href=vittighed.asp?mode=add><strong><font face=verdana size=4>Tilføj ny vittighed!</font></strong></a></p>"
End Select
%>
--------------------------------------
