Solved

Changing Text color based on value of query

Posted on 2004-04-27
7
273 Views
Last Modified: 2013-12-24
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.
0
Comment
Question by:tmurray22
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 7

Expert Comment

by:MaB
ID: 10929469
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!
0
 
LVL 12

Expert Comment

by:rcmb
ID: 10929541
In your database results display page switch to html view and find

<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="56121" -->

Immediately after this code enter

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

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

<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Name,Modified,CDDVDClientJob" s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn" endspan i-CheckSum="3900" -->

This is the webbot results for displaying your field information

bracket this information with
<font color="<%=varFontColor%>"><%=varBstart%>........<%=varBend%></font>

RCMB

0
 

Author Comment

by:tmurray22
ID: 10933275
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>

<p align="center"><img border="0" src="susheader.jpg" width="614" height="111"></p>
<table width="100%" border="1">
  <thead>
    <tr>
      <th ALIGN="LEFT">UPDATE</th>
      <th ALIGN="LEFT"><b>SystemRelease</b></th>
      <th ALIGN="LEFT"><b>BuildStatus</b></th>
      <th ALIGN="LEFT"><b>GatingPtrs</b></th>
      <th ALIGN="LEFT"><b>CurrentBuildNum</b></th>
      <th ALIGN="LEFT"><b>NextBuildNum</b></th>
      <th ALIGN="LEFT"><b>PreviousGABuild</b></th>
      <th ALIGN="LEFT"><b>Comments</b></th>
    </tr>
  </thead>
  <tbody>
    <!--webbot bot="DatabaseRegionStart" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-columntypes="3,202,202,202,202,202,202,202" s-dataconnection="Database6" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="SUtable" s-displaycolumns="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-criteria s-order s-sql="SELECT * FROM SUtable" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% 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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="13228" --><tr>
<%
varStatus = fp_rs("BuildStatus")
If varStatus = "red" OR varStatus = "Red" Then
    varFontColor = "FF0000"
    varBstart = "<b>"
    varBend = "</b>"
Elseif varStatus = "yellow" OR varStatus = "Yellow" Then
    varFontColor = "FFFF00"
    varBstart = "<b>"
    varBend = "</b>"
Elseif varStatus = "green" OR varStatus = "Green" Then
    varFontColor = "00FF00"
    varBstart = "<b>"
    varBend = "</b>"
Else
   varFontColor = ""
    varBstart = ""
    varBend = ""
End if
%>

      <td>
      <p align="center">
      <a href="suedit.asp?ReleaseID=<%=FP_FieldURL(fp_rs,"ReleaseID")%>">Edit</a></td>
      <td>
      <font color=<%=varFontColor%>"><%=varBstart%></font><!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="SystemRelease" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;SystemRelease&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"SystemRelease")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36759" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="BuildStatus" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;BuildStatus&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"BuildStatus")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32721" --></font></p>
      </td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="GatingPtrs" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GatingPtrs&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"GatingPtrs")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29459" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="CurrentBuildNum" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;CurrentBuildNum&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"CurrentBuildNum")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="40737" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="NextBuildNum" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;NextBuildNum&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"NextBuildNum")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="27508" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="PreviousGABuild" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;PreviousGABuild&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"PreviousGABuild")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="34608" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="Comments" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Comments&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Comments")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16369" --></td>
    </tr>
    <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" -->
<%=varBend%></font>
</tbody>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p align="center"><a href="SUS.asp">HOME</a></p>

</body>

</html>
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 12

Expert Comment

by:rcmb
ID: 10933437
Found a few mistakes
Starting with <p align="center"> 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 <font color=<%=varFontColor%>"><%=varBstart%></font>

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

then after your data put <%=varBend%></font>

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

RCMB

      <p align="center">
      <a href="suedit.asp?ReleaseID=<%=FP_FieldURL(fp_rs,"ReleaseID")%>">Edit</a></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="SystemRelease" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;SystemRelease&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"SystemRelease")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36759" --></td>
      <td>
      <font color="<%=varFontColor%>"><%=varBstart%><!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="BuildStatus" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;BuildStatus&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"BuildStatus")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32721" --><%=varBend%></font></p>
      </td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="GatingPtrs" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GatingPtrs&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"GatingPtrs")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29459" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="CurrentBuildNum" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;CurrentBuildNum&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"CurrentBuildNum")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="40737" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="NextBuildNum" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;NextBuildNum&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"NextBuildNum")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="27508" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="PreviousGABuild" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;PreviousGABuild&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"PreviousGABuild")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="34608" --></td>
      <td>
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ReleaseID,SystemRelease,BuildStatus,GatingPtrs,CurrentBuildNum,NextBuildNum,PreviousGABuild,Comments" s-column="Comments" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Comments&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Comments")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16369" --></td>
    </tr>
    <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" -->
<%=varBend%></font>
</tbody>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p align="center"><a href="SUS.asp">HOME</a></p>

</body>

</html>
0
 
LVL 12

Accepted Solution

by:
rcmb earned 500 total points
ID: 10933464
I just noticed another mistake

at the bottom of the page you will find

<%=varBend%></font>
</tbody>

Delete the <%=varBend%></font>

RCMB
0
 

Author Comment

by:tmurray22
ID: 10939044
Thanks RCMB,
 works like a champ. You know your FP.



tmurray22
0
 
LVL 12

Expert Comment

by:rcmb
ID: 10939309
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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Nodejs not returning the response body as expected 4 161
Migrating PC with Oracle TOAD installed. 5 49
How to convert ASPX website to HTML? 3 80
Advanced Visual HTML Editor 2 94
When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question