Mike,
First, I'd make absolutely sure that the bgcolor setting is what's hurting
you. Clip out the whole bgcolor="..." parameter, then take another look.
If you still see a problem, I'd cut out all the formatting: see whether the
data is coming out duplicated.
If the problem suddenly leaves, I'd try double quotes around the color
specifications, i.e., ...DE("ffffff")...
then I would try the color specifications in all caps, i.e.,
...DE('FFFFFF')...
then I would try both, i.e., ...DE("FFFFFF")...
I don't know that those things matter, but they're worth a try.
Championing the trial-and-error approach,
Matthieu
-----Original Message-----
From: Mike Brunt [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 3:58 PM
To: CF-Talk
Subject: Alternating table row colors producing duplicated output
Can anyone see why this code is producing duplicated output for every
record. This ran perfectly in the local dev enironment using CF5.0 and
Access 2000. Moved to staging using CF50 and SQL2000 we are getting each
record twice. Here is the code: -
<cfoutput query="ProdSupSel">
<tr bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('dededf'))#"
valign="top">
<td><font face="Verdana" size="-1">#SupplierName#</font></td><td><font
face="Verdana" font size="-1">#City#</font></td> <td><font face="Verdana"
font size="-1">#Comments#</font></td>
</tr>
</cfoutput>
Kind Regards - Mike Brunt
Tel: 562.790.8631
Instant Messaging
AIM: MediaEmbee
Yahoo: MediaEmbeeYH
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
