Folks, I need a little assistance. I've done this in the past but I can't remember how to do it. When I did a Google search for it, I was giving more complicated examples which I don't need because I already have the below.

What I want is for the ASP to change the <td bgcolor> when ever the rs("LOCATION") changes.

Can anyone help?

===================

<%do until rs.EOF%>

        <td><%response.write rs("LOCATION")%></td>
        <td><%response.write rs("NAME")%></td>
        <td><%response.write rs("NUMBER")%></td>

<%rs.MoveNext
loop
rs.close
conn.close%>

Sorry guys, I figure it out. I can't believe I did this. I had the correct code but I was saving my updates in the wrong folder do it was never being read! Sometimes, it's just a matter of double checking ones work. Man do I feel stupid now!

...can you share the code with me, Crabjoe? Thank you!

Mvh
grstad

Sure can grstad
======================

<%trcolor = "1"%>

<%do until rs.EOF%>

        <%If rowcolor<>rs("LOCATION") and trcolor="0" then
        trcolor ="1"
        rowcolor = rs("LOCATION")
        end if

        If rowcolor<>rs("LOCATION") and trcolor="1" then
        trcolor ="0"
        rowcolor = rs("LOCATION")
        end if%>

                <%if trcolor="1" then%>
                <tr bgcolor="#FFCC99">
                <%end if%>

                <%if trcolor="0" then%>
                <tr bgcolor="#FFFF99">
                <%end if%>

                    <td><%response.write rs("LOCATION")%></td>
                    <td><%response.write rs("NAME")%></td>
                    <td><%response.write rs("NUMBER")%></td>

<%rs.MoveNext
loop
rs.close
conn.close%>