You should read this bakery article:
http://bakery.cakephp.org/articles/view/null-behavior
It's not exactly what you want, but should give you some pointers on
the best way to handle the situation.
On 1 Jun, 08:59, Eugene Bolshakov <[EMAIL PROTECTED]> wrote:
> When I want to save a record with some fields set to empty strings
> cake strips them out (from DboSource::create):
>
> >> if ($set === "''") {
> >> unset ($fieldInsert[$i]);
> >> } else {
> >> $valueInsert[] = $set;
> >>}
>
> And since I use MySQL 5 and the fields that I'm trying to save empty
> strings to are NOT NULL I get an error from MySQL (from mysql docs):
>
> As of MySQL 5.0.2, if a column definition includes no explicit DEFAULT
> value, MySQL determines the default value as follows:
>
> If the column can take NULL as a value, the column is defined with an
> explicit DEFAULT NULL clause. This is the same as before 5.0.2.
>
> If the column cannot take NULL as the value, MySQL defines the column
> with no explicit DEFAULT clause. For data entry, if an INSERT or
> REPLACE statement includes no value for the column, MySQL handles the
> column according to the SQL mode in effect at the time:
>
> * If strict SQL mode is not enabled, MySQL sets the column to the
> implicit default value for the column data type.
> * If strict mode is enabled, an error occurs for transactional
> tables and the statement is rolled back. For non-transactional tables,
> an error occurs, but if this happens for the second or subsequent row
> of a multiple-row statement, the preceding rows will have been
> inserted.
>
> Text/blob fields can't have a default value, so I don't see a way for
> me to solve this other than to alter cake DboSource::create code, but
> I'm really interested why does DboSource::create strips empty strings,
> what is the reason for this and what is the best solution here?
>
> Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
