just do a CFIF letter = "K" set color ="whatever" hehehehe
>From: "Ann Harrell" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Different font colors by Event Code
>Date: Mon, 07 May 2001 16:40:26 -0500
>
>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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
