NEQ "" is working as it should.  The problem is that imagepath might have some spaces in it.  So you must trim it.

use this instead

CFIF trim(imagepath) NEQ ""
  ----- Original Message -----
  From: Daniel Kessler
  To: CF-Talk
  Sent: Thursday, July 08, 2004 10:56 AM
  Subject: NEQ ""

  I have a DB where I insert text from a form.  If the text is blank, I
  still go through and insert it.  I thought I could check on it in the
  display area with:

  <CFOutput query="people_search">
        <cfset the_image = 'img src="">         <cfif imagePath NEQ "">
             <cfset the_image = 'img src="">         </cfif>
  ....

  The NEQ "" doesn't seem to work in this situation.  It doesn't like
  <cfif imagePath NEQ NULL>.  So what should I do to see if this field
  is empty or not?

  thanks.

  --
  Daniel Kessler

  Department of Public and Community Health
  University of Maryland
  Suite 2387 Valley Drive
  College Park, MD  20742-2611
  301-405-2545 Phone
  www.phi.umd.edu
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to