Change table background colour

June 3rd, 2011, 04:41 AM

Hi

The code I am using is listed below, my problem is that it will work when running as localhost on my laptop but will not work when running on the server.

I want the code to change the background colour of a table according to the profit or loss in a contract. The figure is obtained from a query and then I assign this value to a variable "profitloss" and then depending on the value change the colour accordingly.

As I said earlier I cannot understand why it work on my laptop but not the server. Is there a setting within IIS or is my code wrong?

Thanks for any help

Peter

Part of code as follows:

oRs.Open strSQL, conn
While Not oRs.EOF
profitloss=oRs("PL")
bgPL="#2008FD"
%>
<form name="frmResult">
<%

IF profitloss < -1000.00 THEN %>
<table border="1" width="848" bgcolor="#FBA2A8" cellpadding="1" cellspacing="1">
<tr>
<td colspan="4" align="center"><font size="4" color="<%=bgPL%>" ><b><%=oRs("Operator")%></b></font></td>
</tr>
<tr>
<td width="50%" align="center"><font size="4" color="<%=bgPL%>"><b><%=oRs("REG NO")%></b></font></td>
<td width="50%" align="center"><font size="4" color="<%=bgPL%>"><b><%=oRs("CONT TYPE")%></b></font></td>
</tr>
</table>

<% ELSEIF profitloss > -1000.00 THEN %>
<table border="1" width="848" bgcolor="#91FB88" cellpadding="1" cellspacing="1">
<tr>
<td colspan="4" align="center"><font size="4" color="<%=bgPL%>"><b><%=oRs("Operator")%></b></font></td>
</tr>
<tr>
<td width="50%" align="center"><font size="4" color="<%=bgPL%>"><b><%=oRs("REG NO")%></b></font></td>
<td width="50%" align="center"><font size="4" color="<%=bgPL%>"><b><%=oRs("CONT TYPE")%></b></font></td>
</tr>
</table>
<% ELSE %>

<table border="1" width="848" bgcolor="#FCFBFB" cellpadding="1" cellspacing="1">
<tr>
<td colspan="4" align="center"><font size="4" color="<%=bgPL%>"><b><%=oRs("Operator")%></b></font></td>
</tr>
<tr>
<td width="50%" align="center"><font size="4" color="<%=bgPL%>"><b><%=oRs("REG NO")%></b></font></td>
<td width="50%" align="center"><font size="4" color="<%=bgPL%>"><b><%=oRs("CONT TYPE")%></b></font></td>
</tr>
</table>

<% END IF %>

om_prakash · June 3rd, 2011, 05:47 AM

Try using
<table style="background-color:#FBA2A8">
instead of
bgcolor="#FBA2A8"

Imar · June 3rd, 2011, 05:54 AM

Could there be a difference in Regional settings on your machine and the server?

Maybe -1000.00 is seen as different numbers on each machine?

Imar

June 3rd, 2011, 06:46 AM

Hi

I have changed the table style as suggested but again it will work on the laptop but not the server.

It seems that the server will change the background colours as follows

If the record does not fit either criteria ie else statement the background is correct as white.

When the record matches either of the other criteria it will only change the background to the first option ie red.

It seems that the variable "profitloss" is not clearing

Peter

June 3rd, 2011, 09:59 AM

Hi

I have just added into the code the following

Response.Write("profitloss = " & profitloss & "")

On my laptop it shows the value of the query, but on the server it only shows a zero.

So for some reason the variable is not being assigned the value on the server

Has anyone any ideas please, I have checked the number formats on the server are the same

Regards
Peter

Imar · June 3rd, 2011, 05:47 PM

Hi Peter,

Since that value is coming from the database, there might be an issue with your query or data.....

Imar

June 6th, 2011, 02:51 AM

Hi Imar

Thanks very much for all your help - the problem was the data format, the website database is a replica of the main data, I did a resync and it worked okay, something must have occurred with an earlier sync.

Thanks again
Peter