Additional thought - I remember that it had to do a lot with how I did inserts into the database with Witango.
If I included the column in the insert but left the column blank it would result in '' so I have done several things 1. wrapped code around 2 inserts that checked for column length 2. setup a simple @IF in the that would explicitly place "NULL" if the length was less than 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: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:57 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: empty argument 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
