hjælp behøves hurtigt
Denne side bliver ikke vist korrekt på min udbyder server (den er ok hjemme)Den skriver ikke intkampnr og strtegn1, men det gør den på min personal server.
Jeg har testet for om ugenavnet skal være på engelsk.
<%
if session(\"ID\")>0 then %>
<%
if weekdayName(WeekDay(now())) = \"fredag\" then
intLastGameDay = vbFriday
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
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;\"
intSpilnr = GetGameNumber(Now())
\'for a = 1 to 30
SQL = \"select * from Spil\"&intSpilnr&\" order by ID\"
%>
<html>
<head>
<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\">
<LINK href=\"ny.css\" rel=\"stylesheet\" type=\"text/css\">
<title>Tipsturnering</title>
</head>
<body bgcolor=\"#C0C0C0\">
<div align=\"center\">
<center>
<table border=\"0\" bgcolor=\"#FFE430\" style=\"border: 5 double #000000\">
<tr>
<td valign=\"top\">
<p>
<%
set RS = DB.execute( SQL )
if RS.eof then
response.write \"Der ingen deltagere, som har tippet.\"
else
do while not RS.eof
intIdnr = RS(\"ID\")
SQL1 = \"SELECT * FROM deltagere where ID = \"&RS(\"ID\")&\"\"
set RS1=DB.execute(SQL1)
x=0
i=0
for b = 0 to 38
if RS(\"sikre\"&b&\"\")= \"Sand\" then
if b = 0 OR b=3 OR b=6 OR b=9 OR b=12 OR b=15 OR b=18 OR b=21 OR b=24 OR b=27 OR b=30 OR b=33 OR b=36 then
strtegn1 = \"1\"
i=(b+3)/3
elseif b = 1 OR b=4 OR b=7 OR b=10 OR b=13 OR b=16 OR b=19 OR b=22 OR b=25 OR b=28 OR b=31 OR b=34 OR b=37 then
strtegn1 = \"X\"
intnr=(b+2)/3
else
strtegn1 = \"2\"
i=(b+1)/3
end if
intkampnr1 = i
x=b+1
Exit for
end if
next
for b =x to 38
if RS(\"sikre\"&b&\"\")= \"Sand\" then
if b = 0 OR b=3 OR b=6 OR b=9 OR b=12 OR b=15 OR b=18 OR b=21 OR b=24 OR b=27 OR b=30 OR b=33 OR b=36 then
strtegn2 = \"1\"
i=(b+3)/3
elseif b = 1 OR b=4 OR b=7 OR b=10 OR b=13 OR b=16 OR b=19 OR b=22 OR b=25 OR b=28 OR b=31 OR b=34 OR b=37 then
strtegn2 = \"X\"
i= (b+2)/3
else
strtegn2 = \"2\"
i= (b+1)/3
end if
intkampnr2 = i
x=b+1
Exit for
end if
next
for b = x to 38
if RS(\"sikre\"&b&\"\")= \"Sand\" then
if b = 0 OR b=3 OR b=6 OR b=9 OR b=12 OR b=15 OR b=18 OR b=21 OR b=24 OR b=27 OR b=30 OR b=33 OR b=36 then
strtegn3 = \"1\"
inti= (b+3)/3
elseif b = 1 OR b=4 OR b=7 OR b=10 OR b=13 OR b=16 OR b=19 OR b=22 OR b=25 OR b=28 OR b=31 OR b=34 OR b=37 then
strtegn3 = \"X\"
inti= (b+2)/3
else
strtegn3 = \"2\"
inti= (b+1)/3
end if
intkampnr3 = i
Exit for
end if
next
%>
<font size=\"2\">Bruger: <b><%=RS1(\"user\")%></b></font></p>
<blockquote>
<blockquote>
<b><font size=\"2\">Enkeltrække:</font></b>
<table border=\"0\">
<tr>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk1\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk2\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk3\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk4\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk5\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk6\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk7\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk8\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk9\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk10\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk11\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk12\")%></font></td>
<td align=\"center\"><font size=\"2\"> <%=RS(\"enk13\")%></font></td>
</tr>
</table>
<table border=\"0\">
<tr>
<td><b><font size=\"2\">Sikre</font></b></td>
<td> </td>
<td><font size=\"1\">Kampnr</font></td>
<td><font size=\"1\"> </font></td>
<td><font size=\"1\">Tegn</font></td>
<td><font size=\"2\"> </font></td>
<td><font size=\"2\"> </font></td>
<td><b><font size=\"2\">Resultat</font></b></td>
<td><font size=\"2\"> </font></td>
<td><font size=\"1\">Kampnr</font></td>
<td><font size=\"1\"> </font></td>
<td colspan=\"3\"><font size=\"1\">resultat</font></td>
</tr>
<tr>
<td></td>
<td></td>
<td align=\"center\"><font size=\"1\"><%=intkampnr1%></font></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=strtegn1%></font></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res11\")%></font></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res12\")%></font></td>
<td align=\"center\"><font size=\"1\">-</font></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res13\")%></font></td>
</tr>
<tr>
<td></td>
<td></td>
<td align=\"center\"><font size=\"1\"><%=intkampnr2%></font></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=strtegn2%></font></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res21\")%></font></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res22\")%></font></td>
<td align=\"center\"><font size=\"1\">-</font></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res23\")%></font></td>
</tr>
<tr>
<td></td>
<td></td>
<td align=\"center\"><font size=\"1\"><%=intkampnr3%></font></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=strtegn3%></font></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res31\")%></font></td>
<td align=\"center\"></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res32\")%></font></td>
<td align=\"center\"><font size=\"1\">-</font></td>
<td align=\"center\"><font size=\"1\"><%=RS(\"res33\")%></font></td>
</tr>
</table>
</blockquote>
</blockquote>
<hr>
<%
RS.movenext
loop
end if
DB.Close
set DB = Nothing
%>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
Der mangler den sidste bid kode, som er den samme som ovenstående når det ikke er fredag
