<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859- 1"> <title>Over/Under - Handicap</title> <link rel="stylesheet" type="text/css" href="../include/style.css"> <%
flag=0
color1="#d6efff"
function changecolor()
if flag=0 then
flag=1
color1="White"
else
flag=0
color1="#D6E7fF"
end if
end function
%>
</head>
<body>
<Table border=1 cellpadding=2 cellspacing=0 style="border-collapse:
collapse" bordercolor="#ababab" width="600">
<TR bgcolor="DarkBlue">
<th>Match</th>
<TH>HDP</TH>
<TH>H</TH>
<TH>A</TH>
<TH>S</TH>
<TH>GOAL</TH>
<TH>Over</TH>
<TH>Under</TH>
<TH>S</TH>
</TR>
<!-- #include virtual="local/include/adovbs.inc"-->
<!-- #include virtual="local/include/Connect.inc" -->
<%set rs1 =
server.CreateObject("ADODB.Recordset")
sql1 = " select league from
odds where status<>'Closed'"
sql1 = sql1 &" group by
league"
rs1.open sql1,objconn
while not rs1.eof%>
<TR bgcolor="Darkblue">
<TH colspan="10"><%=rs1
("league")%><%league=rs1("league")%></TH>
</TR>
<% set rs = server.CreateObject
("ADODB.Recordset")
SQL = " select DISTINCT *
from odds where"
SQL = SQL &" type='Handicap' and
league='" & League & "'"
rs.open sql, objconn
while not rs.eof
if rs("status")<>"Closed" then%>
<tr bgcolor=<%=color1%>
onmouseover="bgColor='#ffff00'" onmouseout="bgColor='<%=color1%>'" >
<%if rs("hdpa") = 0.00
then
hdp = rs("hdpb")%>
<TD><%=rs("home")%> - <Font
color="#FF0000"><%=rs("away")%></Font></TD>
<%elseif request
("hdpb") = 0.00 then
hdp = rs("hdpa")%>
<TD><Font color="#FF0000"><%
=rs("home")%></Font> - <%=rs("away")%></TD>
<%else
hdp= rs("hdpa")%>
<TD><%=rs("home")%> - <%=rs
("away")%></TD>
<%end if%>
<TD><%=hdp%></TD>
<TD><A href="change.asp?
oddsid=<%=rs("oddsid")%>" target="rightframe"><%=formatnumber(rs
("oddsa"),3)%></a></TD>
<TD><A href="change.asp?
oddsid=<%=rs("oddsid")%>" target="rightframe"><%=formatnumber(rs
("oddsb"),3)%></a></TD>
<TD>
<%if rs("status")
="Running" then%>
<a href="status.asp?
oddsid=<%=rs("oddsid")%>&status=Suspend">S</a>
<%else%>
<a href="status.asp?
oddsid=<%=rs("oddsid")%>&status=Running">R</a>
<%end if%>
<%eventid = rs
("eventid")%>
</TD>
<%set RSou = server.CreateObject("ADODB.Recordset")
SQLou = " select DISTINCT * from odds where"
SQLou = SQLou &" (status='Running' or status='Suspend' or
status='Internal')"
SQLou = SQLou &" AND type='Over/Under' and eventid="
SQLou = SQLou & eventid
rsou.Open SQLou,objConn,3,3
while not rsou.EOF
changecolor()
if rsou("status")="Closed" then%>
</TR>
<%else%>
<TD><%=rsou("hdpa")%></TD>
<TD><A href="change.asp?
oddsid=<%=rsou("oddsid")%>" target="rightframe"><%=formatnumber(rsou
("oddsa"),3)%></a></TD>
<TD><A href="change.asp?
oddsid=<%=rsou("oddsid")%>" target="rightframe"><%=formatnumber(rsou
("oddsb"),3)%></a></TD>
<TD>
<%if rsou("status")
="Running" then%>
<a href="status.asp?oddsid=<%
=rsou("oddsid")%>&status=Suspend">S</a>
<%else%>
<a href="status.asp?oddsid=<%
=rsou("oddsid")%>&status=Running">R</a>
<%end if%>
</TD>
<%end if%>
<%rsou.movenext
wend
end if
rs.movenext
wend
%>
</TR>
<%set rs = server.CreateObject
("ADODB.Recordset")
SQL = " select DISTINCT * from odds where"
SQL = SQL &" type='Handicap' and league='"
& league & "'"
rs.open sql, objconn
while not rs.eof%>
<%if rs("status")="Closed" then%>
<%eventid = rs("eventid")%>
<%set RSou = server.CreateObject("ADODB.Recordset")
SQLou = " select DISTINCT * from odds where"
SQLou = SQLou &" (status='Running' or status='Suspend' or
status='Internal')"
SQLou = SQLou &" AND type='Over/Under' and eventid="
SQLou = SQLou & eventid
rsou.Open SQLou,objConn,3,3
while not rsou.EOF
changecolor()%>
<tr bgcolor=<%=color1%>
onmouseover="bgColor='#ffff00'" onmouseout="bgColor='<%=color1%>'" >
<TD><%=rsou("home")%> - <%
=rsou("away")%></TD>
<TD></TD>
<TD></TD><TD></TD><TD></TD>
<TD><%=rsou("hdpa")%></TD>
<TD><A href="change.asp?
oddsid=<%=rsou("oddsid")%>" target="rightframe"><%=formatnumber(rsou
("oddsa"),3)%></a></TD>
<TD><A href="change.asp?
oddsid=<%=rsou("oddsid")%>" target="rightframe"><%=formatnumber(rsou
("oddsb"),3)%></a></TD>
<TD>
<%if rsou("status")
="Running" then%>
<a href="status.asp?oddsid=<%
=rsou("oddsid")%>&status=Suspend">S</a>
<%else%>
<a href="status.asp?oddsid=<%
=rsou("oddsid")%>&status=Running">R</a>
<%end if%>
</TD>
</TR>
<%rsou.movenext
wend%>
<%end if
rs.movenext
wend
rs1.movenext
wend%>
</TR>
</table>
<%
set objConn = Nothing
%>
</body>
</html>
--- In [email protected], "pfrenchy"
<[EMAIL PROTECTED]> wrote:
> Put some code in here so we can understand what your doing. Or try
to help
> you figure out your problem.
> ----- Original Message -----
> From: "Cady" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Friday, February 25, 2005 3:31 PM
> Subject: [AspClassicAnyQuestionIsOk] problem..!!!!can't figure
this out
>
>
> >
> >
> > hi guys. i have a problem here and i hope someone in the groups
can
> > solve this matter for me..
> > ok the problem is like this
> > i have a table fill with a bunch a data such like number /
money /price
> >
> > now if the number / money /price changes i want the table cell
where
> > the number were, blink..indicating that the value have changes..
> >
> > i'm doing a live stock exchange programme using ASP. i know i
> > shouldn't ask this question here. coz this isn't related anyhow
to
> > this groups..
> > but i'm hoping that someone can give me a light about this..
> >
> > i've tried everything..with no success..!!!!
> >
> > anyone help would be appreciate..JUST GIMME some LIGHT bout
> > this..thank you
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
