Haster--> Connection kludret ind i script
Jeg skal ha en connection til db.mdb kludret ind i dette script sådan det kommer til og virke.<%
Response.Expires = 0
%>
<html>
<head>
<meta http-equiv=\"Content-Language\" content=\"da\">
<style TYPE=\"text/css\">
a:link { text-decoration: none}
a:visited { text-decoration: none}
a:active { text-decoration: none}
a:hover { text-decoration: underline overline; color: #425A73;}
body {
background-image: url(images/test_bg.jpg);
background-repeat: no-repeat;
}
</style>
<title>Ugly Award</title>
<base target=\"_blank\">
</head>
<body topmargin=\"3\" link=\"#425A73\" vlink=\"#425A73\" alink=\"#425A73\" background=\"images/test_bg.JPG\" leftmargin=\"20\">
<p align=\"center\">
<p align=\"center\"><br>
<table border=\"0\" width=\"100%\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"100%\">
<div align=\"center\">
<center>
<table border=\"0\" width=\"100%\" background=\"../grafik/dot_left.gif\" cellspacing=\"0\" cellpadding=\"3\">
<tr>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#425A73\"><font color=\"#FFFFFF\" size=\"1\" face=\"Tahoma\">Gives
hvis der kan arbejdes videre på pågåælde emne</font></td>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#425A73\"><font color=\"#FFFFFF\" size=\"1\" face=\"Tahoma\">Gives
hvis et emne er rimeligt</font></td>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#425A73\"><font color=\"#FFFFFF\" size=\"1\" face=\"Tahoma\">Gives
hvis et emne er godt</font></td>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#425A73\"><font color=\"#FFFFFF\" size=\"1\" face=\"Tahoma\">Gives
hvis et emne er rigtig godt</font></td>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#425A73\"><font color=\"#FFFFFF\" size=\"1\" face=\"Tahoma\">Gives
hvis et emne er "kanon" flot</font></td>
</tr>
</table>
</center>
</div>
<table border=\"0\" width=\"100%\" bgcolor=\"#425A73\" cellspacing=\"0\" cellpadding=\"3\">
<tr>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#F7F7F7\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"></td>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#F7F7F7\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"></td>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#F7F7F7\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"></td>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#F7F7F7\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"></td>
<td width=\"20%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#F7F7F7\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"><img border=\"0\" src=\"smile.gif\" width=\"12\" height=\"10\"></td>
</tr>
<tr>
<td width=\"100%\" valign=\"top\" style=\"border: 1 solid #000000\" align=\"center\" bgcolor=\"#F7F7F7\" colspan=\"5\"><font face=\"Tahoma\" size=\"1\"><b>Sortere
via:</b> <a href=\"Winners.asp?sort=dz\" target=\"main\">[ Højeste Scor i Design ]<a><a href=\"Winners.asp?sort=kna\" target=\"main\"> [ Højeste Scor i knapper ]</a><a href=\"Winners.asp?sort=ht\" target=\"main\">[
Højeste Scor i hastighed ]</a> <a href=\"Winners.asp?sort=ind\" target=\"main\">[ Højeste Scor i indhold ]</a><a href=\"Winners.asp?sort=ID\" target=\"main\"> [ Sotere pr. dato
]</a></font></td>
</tr>
</table>
</td>
</tr>
</table>
<div align=\"center\">
<center>
<table border=\"0\" width=\"100%\" bgcolor=\"#425A73\" cellspacing=\"0\" cellpadding=\"2\">
<tr>
<td width=\"16%\" align=\"center\" style=\"border: 1 solid #000000\" bgcolor=\"#425A73\">
<p align=\"center\"><font face=\"Tahoma\" size=\"2\" color=\"#FFFFFF\"><b>Design</b></font></td>
<td width=\"18%\" align=\"center\" bgcolor=\"#425A73\" style=\"border: 1 solid #000000\"><font face=\"Tahoma\" size=\"2\" color=\"#FFFFFF\"><b>Knapper</b></font></td>
<td width=\"17%\" align=\"center\" style=\"border: 1 solid #000000\" bgcolor=\"#425A73\"><font face=\"Tahoma\" size=\"2\" color=\"#FFFFFF\"><b>Hastighed</b></font></td>
<td width=\"20%\" align=\"center\" style=\"border: 1 solid #000000\" bgcolor=\"#425A73\"><font face=\"Tahoma\" size=\"2\" color=\"#FFFFFF\"><b>Indhold</b></font></td>
<td width=\"21%\" align=\"center\" style=\"border: 1 solid #000000\" bgcolor=\"#425A73\"><font face=\"Tahoma\" size=\"2\" color=\"#FFFFFF\"><b>Titel</b></font></td>
</tr>
<form method=\"POST\" action=\"stem.asp\">
<%
intPage = Request(\"page\")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
If Request.QueryString(\"Sort\") <> \"\" Then
strSQL = \"select * from Award Order by \" & Request.QueryString(\"Sort\") & \" DESC\"
\'Response.Write (Strsql)
strDSN = \"DSN=Awardz-Winners\"
rs.Open strSQL, strDSN, 1
If Not (rs.BOF Or rs.EOF) Then
rs.PageSize = 14
rs.AbsolutePage = intPage
intRecCount = rs.PageSize
intPageCount = rs.PageCount
response.write \"<center>\"
Response.Write \"<font face=\'Verdana\' size=\'1\'><b>Side \" & intPage & \" af \" & intPageCount & \"</b>\"
Response.Write \" \"
If Clng(intPage) > 1 Then
Response.Write \"<a href=winners.asp?page=\" & intPage - 1 & \"&sort=\" & Request.QueryString(\"Sort\") & \" target=main><<</a>\"
Else
Response.Write \"<<\"
End If
Response.Write \" \"
If Clng(intPage) < Clng(intPageCount) Then
Response.Write \"<a href=winners.asp?page=\" & intPage + 1 & \"&sort=\" & Request.QueryString(\"Sort\") & \" target=\'main\'>>></a> \"
Else
Response.Write \">>\"
End If
response.write \"</center>\"
Do While Not rs.EOF And intRecCount > 0
response.write\"<tr><td width=\'16%\' align=\'center\' style=\'border: 1 solid #000000\' bgcolor=\'#F7F7F7\'>\"
X = RS(\"dz\")
Do Until X = 0
response.write \"<img src=\"\"smile.gif\"\">\"
X=X-1
loop
Response.write\"</td><td width=\'18%\' align=\'center\' bgcolor=\'#F7F7F7\' style=\'border: 1 solid #000000\'>\"
X = RS(\"kna\")
Do Until X = 0
response.write \"<img src=\"\"smile.gif\"\">\"
X=X-1
Loop
response.write\"</td><td width=\'17%\' align=\'center\' style=\'border: 1 solid #000000\' bgcolor=\'#F7F7F7\'>\"
X = RS(\"ht\")
Do Until X = 0
response.write \"<img src=\"\"smile.gif\"\">\"
X=X-1
Loop
response.write\"</td><td width=\'20%\' align=\'center\' style=\'border: 1 solid #000000\' bgcolor=\'#F7F7F7\'>\"
X = RS(\"ind\")
Do Until X = 0
response.write \"<img src=\"\"smile.gif\"\">\"
X=X-1
Loop
response.write\"</td><td width=\'29%\' align=\'center\' style=\'border: 1 solid #000000\' bgcolor=\'#F7F7F7\'><font face=\'Tahoma\' size=\'1\' color=\'#000000\'><A HREF=\"\"\" & RS(\"ln\") & \"\"\">\" & RS(\"tl\") & \"</a></font></td>\"
intRecCount = intRecCount - 1
rs.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
end if
%>
</table>
</center>
</div>
<%
response.write \"<center>\"
Response.Write \"<font face=\'Verdana\' size=\'1\'>Gå til side: </font>\"
For intNum = 1 To intPageCount
Response.Write \"<font face=\'Verdana\' size=\'1\'><a href=winners.asp?page=\" & intNum & \"&sort=\" & Request.QueryString(\"Sort\") & \" target=\'_self\'>\" & intNum & \"</a>-</font>\"
Next
response.write \"</center>\"
%>
<p align=\"right\"></p>
</form>
</body>
</html>
