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
