Row blinking or Row Red

mateenmohd · January 22nd, 2005, 09:27 AM

how can display the row blinking or row color red in asp ?

I use following coding in asp, how can display the records when payment of customer will due ?
we have number of customer, mostly our customer purchase good on credit basis.
I make report of all customer which payment is due.

I want the with in one month if customer not pay the balance

1. change the color of it row red or
2. this customer name row start blinking ?

How ?

how can use above in following coding that how many customers payment is due ?

<%
set cn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
cn.ConnectionString=" " // connection string
cn.Open

pn=Request.QueryString("pn")

rs.Open "select rec_id,custno,name,posit,pdate,dept,bstatus from customer order by name",cn,3,1

rs.PageSize=1000

Dim fielddata
dim v
v = 1

do while rs.eof=false
if v mod 2 = 0 then // if payment due this row do blinking or row color red
Response.Write("<tr bgcolor=red>")
else
Response.Write("<tr bgcolor=f8f8ff>")

end if

Response.Write("<td><input type=checkbox name=delrec value='" & rs("rec_id") & "' ></td>")

Response.Write("<td align=center>")
Response.Write("<a target=_self title='Select name' href='update_customer.asp?cust=" & (rs("custno")) & "'>" & rs("custno") & "</a>")
Response.Write("</td>")

Response.Write("<td>" & rs("Name") & "</td>")
Response.Write("<td>" & rs("posit") & "</td>")
Response.Write("<td align=center>" & rs("pdate") & "</td>")
....
...

v = v + 1

rs.movenext
loop

%>
record display like this.

custno..........name................position...... ........pdate
--------------------------------------------------------------------
1212...........John............Engineer........... .....21-1-2005..........// payment due
1013...........King.............Surveyor.......... ......23-1-2005........// payment not due
1014...........Peter............Technician........ .....15-1-2005........// payment due
1014...........Mark............Technician......... ....10-1-2005........// payment due
1013...........Martin............Asstt Engr............25-2-2005.......// payment not due
....
...

John and Peter and Mark payment have due, these row should be blinking or row color become red how ?

regards.

Mateen

Vadivel · January 22nd, 2005, 11:47 AM

Check out this sample code:

<html>
<head>
<script type="text/javascript">
function TextBlinker()
{
   pymtDue = document.getElementById('tblRow1');
   pymtDue.style.visibility=(pymtDue.style.visibility =='visible') ?'hidden':'visible';
}
</script>
</head>
<body onload="setInterval('TextBlinker()',300)">

<table>
  <tr id="tblRow1">
     <td>http://vadivel.thinkingms.com :)</td>
  </tr>
</table>
</body>
</html>

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

mateenmohd · January 24th, 2005, 05:53 AM

thanks for your response.

this sample is good for fix data.

if data are change daily and data received with the database
(sql server) how can use this code ?
what condition will use ?

regards.

Mateen

mat41 · January 24th, 2005, 06:15 PM

The example Vadivel has given is for no particular type of data, its to make a string of text flash. This string can be static or dynamic.

Wind is your friend
Matt

mateenmohd · January 26th, 2005, 05:40 AM

thanks for response.

how can use this string in above coding ?

regards.

Mateen