try this.
<table>
<tr>
<td>#company#</td>
</tr>
<cfif #street# is not "">
<tr>
<td>#Street#</td>
</tr><br>
</cfif>
<tr>
<td>#City#</td>,
<td>#State# </td>
<td>#Zip#</td>
</tr>
</table>
nagesh
-----Original Message-----
From: LH Rothman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 27, 2000 4:33 PM
To: CF-Talk
Subject: Trim Help Needed
Please help with the TRIM function.
My results displays as:
#Company#
#Street#
#City#, #State# #Zip#
However if #Street# contains NO DATA I want Cold Fusion to ignore the
field and not allow any whitespace or new lines. So the data would then
display as:
#Company#
#City#, #State# #Zip#
My problem is that for formatting reasons, I use a <BR> after the
#Street# for those records that DO contain data in the #Street# field.
Is it possible to instruct Cold Fusion to ignore <BR> (or a comma or
whatever) if the field doesn't exist? If so, an example would be
awesome.
Thanks,
-Laura
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
