Conditional Formatting in Table...

[116]

I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David

 

[Stefan B Rusynko]

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David

 

[116]

Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

 

[Stefan B Rusynko]

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

 

[116]

Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.

.

 

[Kathleen Anderson]

Where did you make your changes? You should find the code you want to modify
in the gray-colored code and make your changes. Save the changes while still
in Code view. You will notice that once you've saved your changes they are
also made to the maroon colored code - that is by design. The maroon colored
code should never be touched; it's generated by the gray code at save time.


--

~ Kathleen Anderson
Microsoft MVP - Expression Web
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

Hello Stefan. I jumped the gun on this one. When I attempt to save the
page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all
with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that
with a
couple of tweaks, it can be used in a variety of places?

David

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results
values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default
(say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup
conditional
formatting based on the results. I am not sure if a table or text
fields are
preferred for this. Also where to locate the necessary coding to
perform
this. An example...>60 and <80 would be blue, and greater than 80
would be
green.

Thanks for any assist
David


.

.

 

[Stefan B Rusynko]

The conditional results formatting the OP wants to add is not a change to the webbot code and needs to be done in the results table
html, and not in the webbot code
- see my post above with instructions I provided

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Where did you make your changes? You should find the code you want to modify
in the gray-colored code and make your changes. Save the changes while still
in Code view. You will notice that once you've saved your changes they are
also made to the maroon colored code - that is by design. The maroon colored
code should never be touched; it's generated by the gray code at save time.


--

~ Kathleen Anderson
Microsoft MVP - Expression Web
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

Hello Stefan. I jumped the gun on this one. When I attempt to save the
page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all
with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that
with a
couple of tweaks, it can be used in a variety of places?

David

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results
values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default
(say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup
conditional
formatting based on the results. I am not sure if a table or text
fields are
preferred for this. Also where to locate the necessary coding to
perform
this. An example...>60 and <80 would be blue, and greater than 80
would be
green.

Thanks for any assist
David


.

.

 

[Stefan B Rusynko]

Post the actual Html code for just the table cell, from code view, including the td tags containing the value of your DBRW table
that you are trying to conditionally format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.

.

 

[116]

Hello Stefan,

allset. I see that I went after the code within webbot. I have a question
though. Some of the data entered is N/A. When any of the results contain
this value, the page will not display. If I change the value to a number,
the problem goes away. Thoughts?

David

Post the actual Html code for just the table cell, from code view, including the td tags containing the value of your DBRW table
that you are trying to conditionally format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.

.

.

 

[Stefan B Rusynko]

Presume by N/A you mean the filed value is empty or a Null field in your database
- that will normally cause result and code errors when a value in the database is expected

If your DB field is numeric, in the database you should make it a required field and set a default value of say 0
If the field is actually a text field (with numbers in it), you could do the same and set the same default
- then fill all empty field with the default value

Alternatively you could check for an empty field (length =0) or Null field, with VBscript to prevent errors with the
IsNumeric(fp_rs("YOURFIELDNAME")) and display "N/A" for the value

<td>
<%
strColor="std"
IF NOT IsNull(fp_rs("YOURFIELDNAME")) AND Len(fp_rs("YOURFIELDNAME"))>0 THEN
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
END IF
%>
<span class="<%=strColor%>">
<% IF NOT IsNull(fp_rs("YOURFIELDNAME")) AND Len(fp_rs("YOURFIELDNAME"))>0 THEN %>
fp_rs("YOURFIELDNAMEHERE")
<% ELSE %>
N/A
<% END IF %>
</span>
</td>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan,

allset. I see that I went after the code within webbot. I have a question
though. Some of the data entered is N/A. When any of the results contain
this value, the page will not display. If I change the value to a number,
the problem goes away. Thoughts?

David

Post the actual Html code for just the table cell, from code view, including the td tags containing the value of your DBRW table
that you are trying to conditionally format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.

.

.

 

[116]

Thanks Stefan. Issue resolved. Prior to using DB throught the web, the user
was leaving fields empty.

Thanks again,
David

Presume by N/A you mean the filed value is empty or a Null field in your database
- that will normally cause result and code errors when a value in the database is expected

If your DB field is numeric, in the database you should make it a required field and set a default value of say 0
If the field is actually a text field (with numbers in it), you could do the same and set the same default
- then fill all empty field with the default value

Alternatively you could check for an empty field (length =0) or Null field, with VBscript to prevent errors with the
IsNumeric(fp_rs("YOURFIELDNAME")) and display "N/A" for the value

<td>
<%
strColor="std"
IF NOT IsNull(fp_rs("YOURFIELDNAME")) AND Len(fp_rs("YOURFIELDNAME"))>0 THEN
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
END IF
%>
<span class="<%=strColor%>">
<% IF NOT IsNull(fp_rs("YOURFIELDNAME")) AND Len(fp_rs("YOURFIELDNAME"))>0 THEN %>
fp_rs("YOURFIELDNAMEHERE")
<% ELSE %>
N/A
<% END IF %>
</span>
</td>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan,

allset. I see that I went after the code within webbot. I have a question
though. Some of the data entered is N/A. When any of the results contain
this value, the page will not display. If I change the value to a number,
the problem goes away. Thoughts?

David

Post the actual Html code for just the table cell, from code view, including the td tags containing the value of your DBRW table
that you are trying to conditionally format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

:

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.



.

.

.