What do I have to do ? Can you help me !

minhtri · May 4th, 2004, 04:25 AM

I have an ASP. it like
<%
Dim Cn
Dim Rs
Cn=Server.CreateObject("ADODB.Connection")
Cn=Server.CreateObject("ADODB.Recordset")
Cn.Open ("DSN=Database")
Rs.Open "Select * from MyTableName",Cn,1,2
%>
<Table>
       <Tr>
             <Td>Field name 1</Td>
             <Td>Field name 2</Td>

       </Tr>
<%Do Until Rs.EOF%>

<Tr>
           <Td><%=Rs("fieldname1")%></Td>
           <Td><%=Rs("fieldname2")%></Td>

</Tr>
<%Rs.MoveNext%>
<%Loop%>

</Table>

It has no bug . But what I want is: The background of the table change depend on the Recordset

Ex: The background of the First Recordset is black and The Second is White and
    The third is black and 4th is white and more until Rs.EOF

Thank for your help

bmains · May 4th, 2004, 07:08 AM

Is this color a field of the recordset (Rs("Color")), or could you make it? The only other way is to check the position that the recordset is at, and based on that set the td tag to contain the color as such:

<td color='<%=strColor%>'>

You can check the current record and based on the value use an if or select statement to version, or store the color in the recordset by appending it to the query.

Brian

bmains · May 4th, 2004, 07:12 AM

I forgot to mention that the property is the AbsolutePosition property that denotes the current record.

Imar · May 4th, 2004, 07:30 AM

Alternatively, you can set up a simple loop counter and use the Mod operator to determine the color:

Code:

<%
  Dim BackGroundColor
  Dim LoopCount
  LoopCount = 0

  Do Until Rs.EOF
  If LoopCount Mod 2 = 0 Then
    BackGroundColor = "#00ff00"
  Else
    BackGroundColor = "#cc6666"
  End If
%>
<tr style="background-color:<%=BackGroundColor%>">
  <td><%=Rs("fieldname1")%></td>
  <td><%=Rs("fieldname2")%></td>
</tr>
<%
  Rs.MoveNext
  LoopCount = LoopCount + 1
  Loop
%>

This code will alternate the rows by looking at LoopCount. If LoopCount divided by 2 does not leave a remainder, the color #00ff00 is used, otherwise #cc6666 is used.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Regen En Patchoulli by Spinvis (Track 13 from the album: Spinvis) What's This?