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...
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...