searching for blank

Results 1 to 2 of 2

Thread: searching for blank

  1. #1
    Join Date
    Dec 1969

    Default searching for blank

    I am trying to get records where one of the fields is blank.<BR><BR>sSQL = "SELECT id, project, [description], status FROM proposals WHERE customer_id = " & Request.form("id") & " AND approved=&#039;&#039; ORDER BY approved Desc"<BR><BR>For some reason the statement does not return anything at all.<BR><BR>The field that that I am searching by is a date/time with default value of nothing.<BR><BR>Any ideas?

  2. #2
    Join Date
    Dec 1969

    Default RE: searching for blank

    ... AND approved IS NULL ORDER BY approved DESC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts