Avatar billede monstersurf Praktikant
22. august 2002 - 20:34 Der er 4 kommentarer og
2 løsninger

hvor er fejlen

scriptet:

<%@ LANGUAGE=VBScript%>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>

<body>
<!--#include file="topframe.html"-->

<br>
<%
StrConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("MS.mdb")
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open StrConnect
%>


<%
Set objRec = Server.CreateObject ("ADODB.Recordset")
objRec.Open "cw ORDER BY id;", strConnect, 0,1,2
%>

<title>MS Clan</title>
<TABLE border="1" borderColor="#4682B4" borderColorDark="#000000" borderColorLight="#C0C0C0" width="700">
<br><br>
<TR>

<TD width="100"><font face="arial" size="2" align="center">Date:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">Vs:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">Levels:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">US:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">Them:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">Comments:</font></TD>
</TR>

<%

If objRec("won") = "ja" Then
opwin = "green"
uswin = "red"
else
uswin = "green"
opwin = "red"
End if

%><%
While NOT objRec.EOF

Response.Write "<TR><TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("dato") & "</TD>"
'Response.write "<A href = 'viscw.asp?ID="+CStr(objRec("id"))+"'><font color=#000000>"
'Response.write (objRec("dato"))+CrLf 
'Response.write "</font></a>"+CrLf & "</TD>"


Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("vs") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("level") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2 color="& uswin &">" & objRec("us") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2 color="& opwin &">" & objRec("them") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("comment") & "</TD>"
'Response.write "<A href = 'viscomment.asp?ID="+CStr(objRec("id"))+"'><font color=#000000>"
'Response.write (objRec("comment"))+CrLf 
'Response.write "</font></a>"+CrLf & "</TD></TR>"


objRec.MoveNext

Wend
%>


ka ses http://ms.monstersurf.dk/cw.asp
Avatar billede monstersurf Praktikant
22. august 2002 - 20:34 #1
forresten fejlen er at den ikke laver farverne om i 3. række
Avatar billede monstersurf Praktikant
22. august 2002 - 20:42 #2
hmmm fejlen ligger vel i

<%

If objRec("won") = "ja" Then
opwin = "green"
uswin = "red"
else
uswin = "green"
opwin = "red"
End if

%>
Avatar billede medions Nybegynder
22. august 2002 - 21:12 #3
<%
While NOT objRec.EOF

intFarve = 0
If intFarve = 1 Then
  bg="#FCFCFC"
  Farve= Farve + 1
Else
  bg="#E5E5E5"
  Farve = 1
End If

Response.Write "<TR><TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("dato") & "</TD>"
'Response.write "<A href = 'viscw.asp?ID="+CStr(objRec("id"))+"'><font color=#000000>"
'Response.write (objRec("dato"))+CrLf 
'Response.write "</font></a>"+CrLf & "</TD>"


Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("vs") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("level") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2 color="& bg &">" & objRec("us") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2 color="& bg &">" & objRec("them") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("comment") & "</TD>"
'Response.write "<A href = 'viscomment.asp?ID="+CStr(objRec("id"))+"'><font color=#000000>"
'Response.write (objRec("comment"))+CrLf 
'Response.write "</font></a>"+CrLf & "</TD></TR>"


objRec.MoveNext

Wend
%>

Er det sådan her du mener?

//>Rune
Avatar billede monstersurf Praktikant
22. august 2002 - 21:21 #4
har selv fundet det

<%@ LANGUAGE=VBScript%>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>

<body>
<!--#include file="topframe.html"-->

<br>
<%
StrConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("MS.mdb")
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open StrConnect
%>


<%
Set objRec = Server.CreateObject ("ADODB.Recordset")
objRec.Open "cw ORDER BY id;", strConnect, 0,1,2
%>

<title>MS Clan</title>
<TABLE border="1" borderColor="#4682B4" borderColorDark="#000000" borderColorLight="#C0C0C0" width="700">
<br><br>
<TR>

<TD width="100"><font face="arial" size="2" align="center">Date:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">Vs:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">Levels:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">US:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">Them:</font></TD>
<TD width="100"><font face="arial" size="2" align="center">Comments:</font></TD>
</TR>
<%

While NOT objRec.EOF

Response.Write "<TR><TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("dato") & "</TD>"
'Response.write "<A href = 'viscw.asp?ID="+CStr(objRec("id"))+"'><font color=#000000>"
'Response.write (objRec("dato"))+CrLf 
'Response.write "</font></a>"+CrLf & "</TD>"

if objRec("us") < objRec("them") then
opwin = "green"
uswin = "red"
else
uswin = "green"
opwin = "red"
End if

Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("vs") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("level") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2 color="& uswin &">" & objRec("us") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2 color="& opwin &">" & objRec("them") & "</TD>"
Response.Write "<TD width=200 bgcolor=silver><font face=arial size=2>" & objRec("comment") & "</TD>"
'Response.write "<A href = 'viscomment.asp?ID="+CStr(objRec("id"))+"'><font color=#000000>"
'Response.write (objRec("comment"))+CrLf 
'Response.write "</font></a>"+CrLf & "</TD></TR>"

objRec.MoveNext

Wend
%>
Avatar billede monstersurf Praktikant
22. august 2002 - 21:22 #5
du får ½ da jeg også selv fandt det .. har ikke testet din .. men
Avatar billede medions Nybegynder
22. august 2002 - 21:41 #6
Fair nok
Thx 4 Poinz

//>Rune
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester