Do a trim to make sure that if it takes out the spaces. Cuz i found out
that sometimes SQL appends spaces to my rows that has nothing in it :)
<cfif Trim(qGetLab.Critical_High) NEQ "">
<tr>
<TH>
Critical High
</TH>
<td>
#Critical_high#
</td>
</tr>
</cfif>
>From: "Bruce Sorge" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Something wrong with my CFIF
>Date: Mon, 30 Jul 2001 17:14:16 -0500
>
>If I run any of these;
><cfif qGetLab.Critical_High NEQ "">
> <tr>
> <TH>
> Critical High
> </TH>
> <td>
> #Critical_high#
> </td>
> </tr>
> </cfif>
>
><cfif (qGetLab.Critical_High) NEQ "">
> <tr>
> <TH>
> Critical High
> </TH>
> <td>
> #Critical_high#
> </td>
> </tr>
> </cfif>
>
><cfif (#qGetLab.Critical_High#) NEQ "">
> <tr>
> <TH>
> Critical High
> </TH>
> <td>
> #Critical_high#
> </td>
> </tr>
> </cfif>
>
>and the DB field is empty, I should not see those rows. Problem is, I do
>see those rows, and the DB field is empty. What gives? I have done this a
>thousand times before with no problems.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
