Highlight most recent record 1

[apex82]

I'm displaying records from a database:

While Not obj_RS1.EOF
	Response.Write "<tr>"
        Response.Write "<td>" & obj_RS("Make") & "</td>"
        Response.Write "<td>" & obj_RS("Model") & "</td>"
	Response.Write "<td>" & obj_RS("Delivery Date") & "</td>"
	Response.Write "<td>" & obj_RS("Reg")  & "</td>"
        Response.Write "</tr>"
obj_RS.MoveNext

When they are listed on my page I want to highlight the most recent record which would on the most recent date.
Maybe highlight with the <td> background a different color?

Does anyone know how I could do this?

I've been searching for examples and trying this myself but not had any success.

Thanks.

 

[vicvirk]

Create a counter and give each row an ID

<tr "row_<%=counter%>">
<td>...</td>
<td>...</td>
</tr>

Put that counter within the loop and increment it each time

counter = 0
while not ojb_RS1.eof
counter = counter + 1
...
loop

Keep track of the dates and if the date of the current record is greater than the previous record, set a variable to the value of the counter.

intLatestDate = counter

At the very end of your page, above the body tag add this:

<script language="javascript">
document.getElementById("row_<%=intLatestDate%>").style.background = "#cccccc";
</script>

TIP: trying googling the answer before posting, you'll find that more times than not someone else somewhere has had the same request and posted an answer online.
----
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javascript enabled browsers

 

[apex82]

Brilliant! Thanks vicvirk.

I just can't find a way to add:

<tr "row_<%=counter%>">

after Response.Write

 

[vicvirk]

Response.Write "<tr id=""row_" & counter & "">"
or
Response.Write "<tr id='row_" & counter & "'>"

Haven't tested it, but the first one may have too many/not enough quotes...



TIP: trying googling the answer before posting, you'll find that more times than not someone else somewhere has had the same request and posted an answer online.
----
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javascript enabled browsers

 

[apex82]

Second one worked just great!

Thanks very much!