This only applies to char fields, btw. Numeric & date fields are always NULL when empty. What I do is to make sure that all char fields are initialized to '' so that I can search for that explicitly. Otherwise, I would have to look for both null and '' or use the length trick.
Stefan
At 10:57 AM 9/4/2003 -0700, you wrote:
When is null really a null? I have run into this in SQL Server and SQL Anywhere.
It looks null but is was really '' So if I search for "column is null" nothing would show But if I searched for "column = ''" it would find them
I had to resort to custom column length(column) < 1
Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm
-----Original Message----- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:52 AM To: WiTango List Subject: Witango-Talk: empty argument
I have a search action that looks for <@ARG 1> = column1 AND <@ARG 1> = column2 AND column1 is not NULL AND column2 is not NULL
so if someone does an empty form, it should return nothing. It never does. Always gets a foundset. Same records, in fact. It finds records that have null content in column1 and column2 (mysql)
(I can trap for empty arguments, but this seems odd)
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
========================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
