asked on

Changing Text color based on value of query

I would like to have my results page display the value of the "status" column
with the color of the value.

Example: "status" can be red. yellow or green.
If the "status" is yellow I would like it to display the yellow value in bold yellow text.

MaB

Hi tmurray22,
Do you have a reference page or source to post?

Basicly you can use CSS to accomodate this.
You could name the column with an id, for example id="status", and then apply the style to that elment.

document.getElementById("status").style.color = status

using status as a variable containing any of the colors.

It would be easier to describe and try to solve if you present the code here.

BR MaB!

rcmb

In your database results display page switch to html view and find




Immediately after this code enter

<%
varStatus = fp_rs("Status")
If varStatus = "red" OR varStatus = "Red" Then
varFontColor = "FF0000"
varBstart = ""
varBend = ""
Elseif varStatus = "yellow" OR varStatus = "Yellow" Then
varFontColor = "FFFF00"
varBstart = ""
varBend = ""
Elseif varStatus = "green" OR varStatus = "Green" Then
varFontColor = "00FF00"
varBstart = ""
varBend = ""
Else
varFontColor = ""
varBstart = ""
varBend = ""
End if
%>

In the line where you display you results you will find something like:

<%=FP_FieldVal(fp_rs,"Name")%>

This is the webbot results for displaying your field information

bracket this information with
"><%=varBstart%>........<%=varBend%>

RCMB

tmurray22

ASKER

RCMB

It isn't working, Not sure I Bracketed the information you supplied correctly. I'm not getting any errors just not the color change.

Here is my code

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>SystemRelease</title>
</head>

<body>

<img border="0" src="susheader.jpg" width="614" height="111">
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT">UPDATE</th>
<th ALIGN="LEFT">SystemRelease</th>
<th ALIGN="LEFT">BuildStatus</th>
<th ALIGN="LEFT">GatingPtrs</th>
<th ALIGN="LEFT">CurrentBuildNum</th>
<th ALIGN="LEFT">NextBuildNum</th>
<th ALIGN="LEFT">PreviousGABuild</th>
<th ALIGN="LEFT">Comments</th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM SUtable"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=8 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database6"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ReleaseID=3&SystemRelease=202&BuildStatus=202&GatingPtrs=202&CurrentBuildNum=202&NextBuildNum=202&PreviousGABuild=202&Comments=202&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<%
varStatus = fp_rs("BuildStatus")
If varStatus = "red" OR varStatus = "Red" Then
varFontColor = "FF0000"
varBstart = ""
varBend = ""
Elseif varStatus = "yellow" OR varStatus = "Yellow" Then
varFontColor = "FFFF00"
varBstart = ""
varBend = ""
Elseif varStatus = "green" OR varStatus = "Green" Then
varFontColor = "00FF00"
varBstart = ""
varBend = ""
Else
varFontColor = ""
varBstart = ""
varBend = ""
End if
%>

<td>

<a href="suedit.asp?ReleaseID=<%=FP_FieldURL(fp_rs,"ReleaseID")%>">Edit</a></td>
<td>
"><%=varBstart%><%=FP_FieldVal(fp_rs,"SystemRelease")%></td>
<td>
<%=FP_FieldVal(fp_rs,"BuildStatus")%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"GatingPtrs")%></td>
<td>
<%=FP_FieldVal(fp_rs,"CurrentBuildNum")%></td>
<td>
<%=FP_FieldVal(fp_rs,"NextBuildNum")%></td>
<td>
<%=FP_FieldVal(fp_rs,"PreviousGABuild")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Comments")%></td>
</tr>


<%=varBend%>
</tbody>
</table>
 
 
 
 
<a href="SUS.asp">HOME</a>

</body>

</html>

rcmb

Found a few mistakes
Starting with delete everything from that point and replace with the code after my initials.

I assume you wanted BuildStatus bracketed with the font color changes --

You had "><%=varBstart%>

which should read "><%=varBstart%> your data starts here

then after your data put <%=varBend%>

also you had the code beginning on the line for SystemRelease vice BuildStatus

RCMB


<a href="suedit.asp?ReleaseID=<%=FP_FieldURL(fp_rs,"ReleaseID")%>">Edit</a></td>
<td>
<%=FP_FieldVal(fp_rs,"SystemRelease")%></td>
<td>
"><%=varBstart%><%=FP_FieldVal(fp_rs,"BuildStatus")%><%=varBend%>
</td>
<td>
<%=FP_FieldVal(fp_rs,"GatingPtrs")%></td>
<td>
<%=FP_FieldVal(fp_rs,"CurrentBuildNum")%></td>
<td>
<%=FP_FieldVal(fp_rs,"NextBuildNum")%></td>
<td>
<%=FP_FieldVal(fp_rs,"PreviousGABuild")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Comments")%></td>
</tr>


<%=varBend%>
</tbody>
</table>
 
 
 
 
<a href="SUS.asp">HOME</a>

</body>

</html>

ASKER CERTIFIED SOLUTION

rcmb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tmurray22

ASKER

Thanks RCMB,
works like a champ. You know your FP.

tmurray22

rcmb

Glad to help and hope you enjoy. The power of adding some VBScript to FP is unlimited. You can do things like alternate row colors, change background colors, show different pictures, etc. all based on the results of the db query.

Have fun and thanks for the points.

RCMB