The DB field isn't "".. It's most likely "<NULL>".
Try using "ISNULL" and/or wrap the var with "TRIM".. i.e.,
#trim(myvar)#. That will remove any extraneous spaces.. Etc.
Lee Fuller
Chief Technical Officer
PrimeDNA Corporation / AAA Web Hosting Corporation
"We ARE the net."
http://www.aaawebhosting.com
> -----Original Message-----
> From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 3:14 PM
> To: CF-Talk
> Subject: Something wrong with my CFIF
>
>
> 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
