Totally forgot that. It worked and I thank you.
----- Original Message -----
From: "Fuon See Tu" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 5:22 PM
Subject: Re: Something wrong with my CFIF
> 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
