Hvorfor vil den ikke ??
Hvorfor virker dette ikke ?(GetGameNumber returnerer et tal som svarer til et nummer i databasen, således den automatisk skifter til en ny tabel på et given tidspunkt.
Den vil ikke skrive det til databasen.!
<html>
<head>
<%
intLastGameDay = vbWednesday
intLastGameHour = 23
Function GetGameNumber(strDate)
DIM intB4Hours ' timer der skal kompenceres for
intB4Hours = 24*(vbSaturday-intLastGameDay) + (24-intLastGameHour)
GetGameNumber = DatePart("ww", DateAdd("h",intB4Hours,strDate))
End Function
%>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
<%
if (request("update") <> "Yes") then
response.write "<form action=""funktion.asp"""" method=""POST"">"
%>
<%="Spil"&GetGameNumber(Now())%>
<input type="checkbox" name="tegn1" value="ON"><br>
<input type="checkbox" name="tegn2" value="ON"><br>
<%
response.write "<tr><td width=""87""> </td>"
response.write "<td align=""center"" width=""51""><input value=""Yes"" name=""update"" type=""hidden"">"
response.write "<td colspan=""2"" align=""center""><input type=""submit"" value="" update ""></td>"
response.write "<td align=""center"" width=""62""><font size=""1"" face=""Verdana""><input value=""Yes"" name=""B2"" type=""hidden"">"
response.write "<colspan=""2"" align=""center""><input type=""reset"" value="" Slet alt ""></td></tr>"
response.write "</form>"
response.end
strSpilnavn = "Spil" &GetGameNumber(Now())
set DB = Server.CreateObject("ADODB.Connection")
DB.open "Driver={Microsoft Access Driver (*.mdb)};"&_
"DBQ="&server.mappath("db/tips.mdb")&";"&_
"DefaultDir="&server.mappath("./")&";FIL=MS Access;"
SQL = "SELECT * FROM Tipsdata"
Set DB1 = Server.CreateObject("ADODB.Recordset")
DB1.Open SQL, DB, 3, 3
DB1.AddNew
Tipstegn = Array(tegn1,tegn2)
for b=1 to 2
if Request("tegn"&b&"")="ON" then
DB1("Spil"&GetGameNumber(Now())&"")="True"
else
DB1("Spil"&GetGameNumber(Now())&"")="False"
end if
next
DB1.update
DB.close
end if
%>
</body>
</html>
