You should just use cascading style sheets to create a class for each event
code:
-----------------
<html>
<head>
<title>Harrell Family Schedule</title>
<STYLE>
..S {
font-family : sans-serif;
color : Blue;
font-weight : bold;
}
..N {
font-family : sans-serif;
color : Red;
font-weight : bold;
}
..A {
font-family : sans-serif;
color : Green;
font-weight : bold;
}
..K {
font-family : sans-serif;
color : Yellow;
font-weight : bold;
}
</STYLE>
</head>
<body bgcolor="#FFFFDF" background="fiebkgnd.jpg">
<cfinclude template="Toolbar.cfm">
<CFQUERY NAME="GetEvents" DATASOURCE="schedule">
SELECT bEvent, bTime, bDay, eventcode
FROM bGames
WHERE bDay > (Now())-1
Order BY bGames.bDay
</CFQUERY>
<FONT FACE="Arial" SIZE="+1" COLOR="Red">Report for 6:00 PM game at 5:20 and
7:30 PM game at 6:50 per coach.</FONT>
<TABLE WIDTH="80%" BORDER="1" ALIGN="left">
<TR>
<TH ALIGN="LEFT"><FONT FACE="Arial" SIZE="+2"
COLOR="Navy">Event</font></TH>
<TH ALIGN="LEFT"><font face="Arial" size="+2"
color="#000080">Time</font></TH>
<TH ALIGN="LEFT"><font face="Arial" size="+2"
color="#000080">Date</font></TH>
</TR>
<CFOUTPUT QUERY="GetEvents">
<TR>
<TD CLASS="#GetEvents.eventCode#">#bEvent#</TD>
<TD CLASS="#GetEvents.eventCode#">#bTime#</TD>
<td CLASS="#GetEvents.eventCode#">#DateFormat(bDay, "mmmm dd,
yyyydddd")#</td>
</TR>
</CFOUTPUT>
</TABLE>
</body>
</html>
---------------
CSS can be your best friend.
Craig Fisher
Alta Interactive, Inc.
http://www.altainteractive.com/
[EMAIL PROTECTED]
801-791-8251
-----Original Message-----
From: Ann Harrell [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 07, 2001 3:40 PM
To: CF-Talk
Subject: Different font colors by Event Code
I have this template that returns a list of scheduled events. I am thinking
about adding a code for each event such as S (sam), N (Nick), A (appt) K
(kids to their dad's for the weekend, yeah mom has a day off!!) ect and then
I would like to return each row in a different font color per code. This
would make it easier to read rather than all being in the same color.
Here is what we were using before: http://www.bourbon.org/harrell/
<html>
<head>
<title>Harrell Family Schedule</title>
</head>
<body bgcolor="#FFFFDF" background="fiebkgnd.jpg">
<cfinclude template="Toolbar.cfm">
<CFQUERY NAME="GetEvents" DATASOURCE="schedule">
SELECT bEvent, bTime, bDay
FROM bGames
WHERE bDay > (Now())-1
Order BY bGames.bDay
</CFQUERY>
<FONT FACE="Arial" SIZE="+1" COLOR="Red">Report for 6:00 PM game at 5:20 and
7:30 PM game at 6:50 per coach.</FONT>
<TABLE WIDTH="80%" BORDER="1" ALIGN="left">
<TR>
<TH ALIGN="LEFT"><FONT FACE="Arial" SIZE="+2"
COLOR="Navy">Event</font></TH>
<TH ALIGN="LEFT"><font face="Arial" size="+2"
color="#000080">Time</font></TH>
<TH ALIGN="LEFT"><font face="Arial" size="+2"
color="#000080">Date</font></TH>
</TR>
<CFOUTPUT QUERY="GetEvents">
<TR>
<TD><B><FONT FACE="Arial" COLOR="Navy">#bEvent#</FONT></B></TD>
<TD><B><FONT FACE="Arial" COLOR="Navy">#bTime#</FONT></B></TD>
<td><B><FONT FACE="Arial" COLOR="Navy">#DateFormat(bDay, "mmmm
dd, yyyy
dddd")#</FONT></B></td>
</TR>
</CFOUTPUT>
</TABLE>
</body>
</html>
Ann Harrell
Mind like a steel trap..
Rusty and illegal in 37 states.
Ann Harrell
Mind like a steel trap..
Rusty and illegal in 37 states.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
