[ic] strange database update behavior
peter at pajamian.dhs.org
Sun Sep 13 02:34:49 UTC 2009
On 09/12/2009 07:32 PM, DB wrote:
>> On 09/12/2009 05:43 PM, 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"
>> Fails with what error message?
> That's what's odd - as I said above I see no error in the IC logs, nor
> is any error displayed on the page.
What is the code that you're using to update the table?
More information about the interchange-users