[ic] strange database update behavior

Stefan Hornburg (Racke) racke at linuxia.de
Sun Sep 13 05:52:56 UTC 2009


DB wrote:
> I just noticed a strange (at least to me) behavior in a form that I've
> been using to update a mysql database table.
> 
> The update of a text-type column fails if I attempt to submit an empty
> entry. I see no error in the IC logs. If I instead submit a single space
> (or any other non-empty string) then the update works.
> 
> The column definition is
> 
> Database  transactions  COLUMN_DEF   "notes=text"
> 
> Can anyone explain?

No. Enable MySQL logging and check if there is a query executed.


Regards
           Racke



-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team




More information about the interchange-users mailing list