Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Modify sets '' instead or NULL value. Empty value should be '' or NULL?

Quote Reply
Modify sets '' instead or NULL value. Empty value should be '' or NULL?
Modify sets '' value, instead or NULL value.
Which should be the empty value: '' or NULL ?

My problem is, that ORDER will sort the '' values before NULL values. And originally, when you create a new column, the default values are NULL.
When you modify a link with LSQL, the link field will get '' value :-(
The field is a checkbox, which sets 'Y' value if checked. This will be stored in db.

Should the Modify store NULL instead of '' in the db?

Any idea, solution for the problem?

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Subject Author Views Date
Post Modify sets '' instead or NULL value. Empty value should be '' or NULL? webmaster33 632 Aug 14, 2002, 6:15 AM