Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Alternating row colors 2
- Thread starter KevinFSI
- Start date
-
1
- Thread starter
- #2
Nevermind. I found some old code.
If anyone out there wants the answer, this is how I did it before.
Kevin
slanek@ssd.fsi.com
If anyone out there wants the answer, this is how I did it before.
Code:
<CFIF queryname.currentrow MOD 2 IS
0>bgcolor="mycolor"<CFELSE>
bgcolor="anothercolor"</CFIF>slanek@ssd.fsi.com
ChiefJoseph
Programmer
I was just wondering how do this exact thing!! wierd.. Thanks a ton
-
1
- #4
Just to rewrite the code for non query related loops.
<cfset loopCount = 0>
<cfloop {looping condition}>
<cfif loopCount MOD 2 IS 0>
<cfset myColor = "red">
<cfelse>
<cfset myColor = "ff66ff">
</cfif>
...code <table bgcolor="#myColor#"> ...
<cfset loopCount = loopCount + 1>
</cfloop>
note that if the loop is indexed then the name of the index
can be used instead of creating the variable loopCount
<cfset loopCount = 0>
<cfloop {looping condition}>
<cfif loopCount MOD 2 IS 0>
<cfset myColor = "red">
<cfelse>
<cfset myColor = "ff66ff">
</cfif>
...code <table bgcolor="#myColor#"> ...
<cfset loopCount = loopCount + 1>
</cfloop>
note that if the loop is indexed then the name of the index
can be used instead of creating the variable loopCount
micjohnson
Programmer
You can use this code also
<table>
<cfoutput query="myQuery">
<tr bgcolor="###Iif(((CurrentRow MOD 2) is 0),de('ff3060'),de('ff0000'))#">
<td>#Field1#</td>
<td>#Field2#</td>
</tr>
</cfoutput>
</table>
By(e)
micjohnson
<table>
<cfoutput query="myQuery">
<tr bgcolor="###Iif(((CurrentRow MOD 2) is 0),de('ff3060'),de('ff0000'))#">
<td>#Field1#</td>
<td>#Field2#</td>
</tr>
</cfoutput>
</table>
By(e)
micjohnson
this is just for not using MOD and it's simple.
<cfset bgcolor="oneColor">
<cfloop query="query">
<cfif bgcolor is "oneColor">
<cfset bgcolor = "anotherColor">
<cfelse>
<cfset bgcolor = "oneColor">
</cfif>
</cfloop>
<cfset bgcolor="oneColor">
<cfloop query="query">
<cfif bgcolor is "oneColor">
<cfset bgcolor = "anotherColor">
<cfelse>
<cfset bgcolor = "oneColor">
</cfif>
</cfloop>
scripter73
Programmer
Hi,
Does anyone know how to do this within the confines of a <cftable> tag? <cftable> doesn't allow any bgcolor attributes. Following is my code, and every row just defaults to white.
<table width=800 border=1>
<tr>
<cfset #rowcolor# = 'white'>
<td bgcolor="<cfoutput>#rowcolor#</cfoutput>">
<CFTABLE Query="achdata" HTMLTABLE BORDER COLHEADERS MAXROWS=200>
<CFCOL Header="<B>Branch Code</B>" Width=8 Text="#wach_branch_code#">
<CFCOL Header="<B>Agent Code</B>" Width=8 Text="#wach_agent_code#">
<CFCOL Header="<B>Ins Last Name</B>" Width=20 Align=Right Text="#wach_ins_last_name#">
<CFCOL Header="<B>Ins First Name</B>" Width=10 Align=Right Text="#wach_ins_first_name#">
<CFCOL Header="<B>M.I.</B>" Width=5 Align=Right Text="#wach_ins_middle_initial#">
<CFCOL Header="<B>Tran Date</B>" Width=10 Align=Right Text="#wach_tran_date#">
<CFCOL Header="<B>Binder Number</B>" Width=15 Align=Right Text="#wach_binder_number#">
<CFCOL Header="<B>Bank Account Number</B>" Width=17 Align=Right Text="#wach_bank_account_num#">
<CFCOL Header="<B>Bank Amount</B>" Width=10 Align=Right Text="#wach_bank_amount#">
</CFTABLE>
<cfif (#achdata.currentrow# mod 2) eq 0>
<cfset #rowcolor# = 'white'>
<cfelse>
<cfset #rowcolor# = 'blue'>
</cfif>
</td>
</tr>
</table>
Thanks in advance,
scripter73
Does anyone know how to do this within the confines of a <cftable> tag? <cftable> doesn't allow any bgcolor attributes. Following is my code, and every row just defaults to white.
<table width=800 border=1>
<tr>
<cfset #rowcolor# = 'white'>
<td bgcolor="<cfoutput>#rowcolor#</cfoutput>">
<CFTABLE Query="achdata" HTMLTABLE BORDER COLHEADERS MAXROWS=200>
<CFCOL Header="<B>Branch Code</B>" Width=8 Text="#wach_branch_code#">
<CFCOL Header="<B>Agent Code</B>" Width=8 Text="#wach_agent_code#">
<CFCOL Header="<B>Ins Last Name</B>" Width=20 Align=Right Text="#wach_ins_last_name#">
<CFCOL Header="<B>Ins First Name</B>" Width=10 Align=Right Text="#wach_ins_first_name#">
<CFCOL Header="<B>M.I.</B>" Width=5 Align=Right Text="#wach_ins_middle_initial#">
<CFCOL Header="<B>Tran Date</B>" Width=10 Align=Right Text="#wach_tran_date#">
<CFCOL Header="<B>Binder Number</B>" Width=15 Align=Right Text="#wach_binder_number#">
<CFCOL Header="<B>Bank Account Number</B>" Width=17 Align=Right Text="#wach_bank_account_num#">
<CFCOL Header="<B>Bank Amount</B>" Width=10 Align=Right Text="#wach_bank_amount#">
</CFTABLE>
<cfif (#achdata.currentrow# mod 2) eq 0>
<cfset #rowcolor# = 'white'>
<cfelse>
<cfset #rowcolor# = 'blue'>
</cfif>
</td>
</tr>
</table>
Thanks in advance,
scripter73
- Status
Similar threads
- Locked
- Question