Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 1st, 2007, 06:39 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default Date <= change row color

I am using following code/loop to dislay the record information
this is safety certificate records information,

Dim fielddata
dim v
v = 1

do while rs.eof=false
if v mod 2 = 0 then
   Response.Write("<tr bgcolor=#e3effe>")
else
   Response.Write("<tr bgcolor=f8f8ff>")

end if

Response.Write("<td align=left>" & rs("Name") & "</td>")
Response.Write("<td align=left>" & rs("SOP_NAME") & "</td>")
Response.Write("<td align=center>" & rs("DATE_CERTIFICATE") & "</td>")
...
....


v = v + 1

rs.movenext
loop

----------------------------
I want that When certificate date near to expirying it color will display red otherwise no chnage as display in above code.
ie.

if DATE_CERTIFICATE <= (between one week)
 Response.Write("<tr bgcolor=red>")
else
   Response.Write("<tr bgcolor=f8f8ff>")

ie. user cerficate is expired today 1 August 2007, one week
before row will show in red color how ?
what change in above code ?

regard
Mateen







Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the color of selected row of an HTML bhavna HTML Code Clinic 4 February 11th, 2007 09:22 PM
how can i change row color in datagrid? berzegerol VS.NET 2002/2003 3 October 31st, 2006 09:08 AM
datagrid row color change berzegerol Visual Studio 2005 0 October 18th, 2006 06:33 AM
change row color vivek_pon VS.NET 2002/2003 3 April 13th, 2006 01:42 PM
change the color of a row in a Datagrid bimal General .NET 1 October 6th, 2004 03:12 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.