04. november 2003 - 00:28
Der er
3 kommentarer og 1 løsning
alfabetisk orden
Er der en, der kan hjælpe mig med at kalde disse overskrifter i alfabetisk orden? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Systematics homekitchen</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } //--> </script> <link href="ego.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- @import url("systematic.css"); --> </style> <style> BODY { SCROLLBAR-FACE-COLOR: #ffffff; SCROLLBAR-HIGHLIGHT-COLOR: #ff0000; SCROLLBAR-SHADOW-COLOR: #cccccc; SCROLLBAR-3DLIGHT-COLOR: #DFDFDF; SCROLLBAR-ARROW-COLOR: #ff0000; SCROLLBAR-TRACK-COLOR: #ffffff; SCROLLBAR-DARKSHADOW-COLOR: #ffffff } </style> </head> <body class="broedtxt"> <table width="680" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="80"><img src="grafik/trans.gif" width="80" height="30" border="0"></td> <td> </td> </tr> <tr> <td> </td> <td valign="top" class="overskrifter"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="2%"> <a href="java script: history.go(-1);" onFocus="this.blur()" target="_self"> <img src="grafik/trekant_tilbage.gif" width="12" height="17" border="0"></a></td> <td width="2%"><img src="grafik/trans.gif" width="10" height="6"></td> <td width="96%"><img src="grafik/overskrifter/denvalgteopskrift.gif" width="397" height="24"></td> </tr> <tr> <td> </td> <td> </td> <td><img src="grafik/trans.gif" width="6" height="15"></td> </tr> </table></td> </tr> <tr> <td> </td> <td class="broedtxt"> <% strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("users.mdb") Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN sql = "select * from opskrifter where id = " & request.querystring("id") set objrec = myConn.execute(sql) comment = Replace(objrec("text"), vbCrLf, "<BR>") response.write "<table border=""1"" bordercolor=""#cccccc"" width=""550"" cellpadding=""20"" cellspacing=""3""><tr><td bordercolor=""#cccccc"">" response.write "<table width=""550"" align=""center"" cellpadding=""0"" cellspacing=""0""><tr class=""broedtxt"">" response.write "<span class=""mellemoverskrift"">" & objrec("nick") & "</span>" response.write "</td><td align=""right"" background=""system/td_back.gif"">" response.write "</td></tr>" response.write "<tr><td colspan=""2"">" response.write "<table class=""broedtxt"" cellpadding=""0"" cellspacing=""0"" width=""100%""><tr><td>" response.write comment response.write "</td></tr></table>" response.write "</td></tr>" response.write "<tr class=""datotidDB""><td background=""system/td_back2.gif"">" response.write "date: " & objrec("dato") response.write "</td><td align=""right"" background=""system/td_back2.gif"">" response.write "time: " & objrec("tid") response.write "</td></tr></table>" response.write "</td></tr></table>" response.write "<br><br>" %> </td> </tr> </table> <p> <map name="Image1Map"> <area shape="rect" coords="3,1,110,28" href="#"> </map> <map name="Image2Map"> <area shape="rect" coords="3,1,114,28" href="#"> </map> </p> </body> </html>
Annonceindlæg fra Barco
04. november 2003 - 00:30
#1
Du kan sætte en ORDER BY og så det kolonnenavn du vil sortere på i din SQL: sql = "select * from opskrifter where id = " & request.querystring("id") & " ORDER BY titel"
04. november 2003 - 00:39
#2
Nu har jeg ændret den til dette, men der sker ikke rigtigt noget, kan du se fejlen? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Systematics homekitchen</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } //--> </script> <link href="ego.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- @import url("systematic.css"); --> </style> <style> BODY { SCROLLBAR-FACE-COLOR: #ffffff; SCROLLBAR-HIGHLIGHT-COLOR: #ff0000; SCROLLBAR-SHADOW-COLOR: #cccccc; SCROLLBAR-3DLIGHT-COLOR: #DFDFDF; SCROLLBAR-ARROW-COLOR: #ff0000; SCROLLBAR-TRACK-COLOR: #ffffff; SCROLLBAR-DARKSHADOW-COLOR: #ffffff } </style> </head> <body class="broedtxt"> <table width="680" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="80"><img src="grafik/trans.gif" width="80" height="30" border="0"></td> <td> </td> </tr> <tr> <td> </td> <td valign="top" class="overskrifter"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="2%"> <a href="java script: history.go(-1);" onFocus="this.blur()" target="_self"> <img src="grafik/trekant_tilbage.gif" width="12" height="17" border="0"></a></td> <td width="2%"><img src="grafik/trans.gif" width="10" height="6"></td> <td width="96%"><img src="grafik/overskrifter/denvalgteopskrift.gif" width="397" height="24"></td> </tr> <tr> <td> </td> <td> </td> <td><img src="grafik/trans.gif" width="6" height="15"></td> </tr> </table></td> </tr> <tr> <td> </td> <td class="broedtxt"> <% strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("users.mdb") Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open strDSN ' SQL forespørgsel - asc = sætter opskrifterne i alfabetisk rækkefølge i forhold til 'nick' = navn på opskrift sql = "select * from opskrifter where id = " & request.querystring("id") & " order by nick asc" set objrec = myConn.execute(sql) comment = Replace(objrec("text"), vbCrLf, "<BR>") response.write "<table border=""1"" bordercolor=""#cccccc"" width=""550"" cellpadding=""20"" cellspacing=""3""><tr><td bordercolor=""#cccccc"">" response.write "<table width=""550"" align=""center"" cellpadding=""0"" cellspacing=""0""><tr class=""broedtxt"">" response.write "<span class=""mellemoverskrift"">" & objrec("nick") & "</span>" response.write "</td><td align=""right"" background=""system/td_back.gif"">" response.write "</td></tr>" response.write "<tr><td colspan=""2"">" response.write "<table class=""broedtxt"" cellpadding=""0"" cellspacing=""0"" width=""100%""><tr><td>" response.write comment response.write "</td></tr></table>" response.write "</td></tr>" response.write "<tr class=""datotidDB""><td background=""system/td_back2.gif"">" response.write "date: " & objrec("dato") response.write "</td><td align=""right"" background=""system/td_back2.gif"">" response.write "time: " & objrec("tid") response.write "</td></tr></table>" response.write "</td></tr></table>" response.write "<br><br>" %> </td> </tr> </table> <p> <map name="Image1Map"> <area shape="rect" coords="3,1,110,28" href="#"> </map> <map name="Image2Map"> <area shape="rect" coords="3,1,114,28" href="#"> </map> </p> </body> </html>
04. november 2003 - 00:43
#3
Så skulle den sortere på kolonnen nick, jeg kan ikke umiddelbart se nogen fejl i selve koden.. Har du uploadet filen eller tvunget reload i browseren? Har du et par eksempler på hvad nick indeholder?
04. november 2003 - 09:03
#4
Ja, jeg har uploaded filen og prøvet at tvinge reload i browseren og den sætter dem stadig ikke i alfabetiskorden. Min database indeholder ID, nick (som indeholder overskrifter), e-mail (som ikke er synlig), text (som er selve opskriften), dato og tid. Hjælper det dig yderligere til at se fejlen? Eller skal jeg måske prøve at sende dig alle filerne vedr. dette? //D
Kurser inden for grundlæggende programmering