1 Reply Latest reply on Mar 23, 2002 11:55 AM by Dain Sundstrom

    calling finder method with null values

    Yan Or Newbie


      i'm having problem with passing null values to a finder
      method. the generated SQL looks like this:

      Executing SQL: SELECT t0_o.id FROM ORDER t0 WHERE t0_o.type = ?

      i want to search for objects where the "type" is null
      but when i pass a null value to the finder, it returns
      0 records. i'm sure there are records with "type"
      column null in the database. my question is, in SQL,
      to search for null columns, don't we need to use the
      "IS NULL" clause instead of "= NULL"? i don't believe
      the above SQL will work for nulls.