I have column heading that need to match this condition but when I do
<CFIF LEN(TRIM(TEST.STATIONID)) GT 0>
<TH>#StationID#</TH>
</CFIF>
I get an error message. The column headings have to match the
condition of only appearing when the column contains data when I output
the query. The headings have to match the output. Any ideas?
<cfoutput query="test">
<tr>
<CFIF LEN(TRIM(TEST.STATIONID)) GT 0>
<TD>#StationID#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.STATION)) GT 0>
<TD>#Station#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.LicenseID)) GT 0>
<TD>#LicenseID#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.Calls)) GT 0>
<TD>#Calls#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.AmFm)) GT 0>
<TD>#AmFm#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.Fill)) GT 0>
<TD>#Fill#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.City)) GT 0>
<TD>#City#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.County)) GT 0>
<TD>#County#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.State)) GT 0>
<TD>#State#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.OnAirStats)) GT 0>
<TD>#OnAirStats#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.Npr)) GT 0>
<TD>#Npr#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.Pri)) GT 0>
<TD>#Pri#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.Rlg)) GT 0>
<TD>#Rlg#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.metrohome)) GT 0>
<TD>#metrohome#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.dmahome)) GT 0>
<TD>#dmahome#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.tally)) GT 0>
<TD>#tally#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.Seesta)) GT 0>
<TD>#Seesta#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.SeeStaType)) GT 0>
<TD>#SeeStaType#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.SeeStaID)) GT 0>
<TD>#SeeStaID#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.freq)) GT 0>
<TD>#freq#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.Oldcalls)) GT 0>
<TD>#Oldcalls#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.Comment)) GT 0>
<TD>#comment#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.tzwi)) GT 0>
<TD>#tzwi#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.tzsp)) GT 0>
<TD>#tzsp#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.tzsu)) GT 0>
<TD>#tzsu#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.tzfa)) GT 0>
<TD>#tzfa#</TD>
</CFIF>
<CFIF LEN(TRIM(TEST.businessnm)) GT 0>
<TD>#businessnm#</TD>
</CFIF>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get help! RoboHelp
http://www.houseoffusion.com/banners/view.cfm?bannerid=58
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1171
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
