Did I get this right: This problem is with datetime-fields when one of your layouts is used bit not the other.
The problem looks a bit like an encoding problem (utf8/latin1) of some kind. I try to make sure that html layouts, Cake's app encoding, sql connection, database, tables and fields... in short: everything uses the same encoding. if you pr (or debug) the data, it will still be output to the browser and to be sure the dashes (minuses) are ok you need to look at the source of the html output. You should start by looking at the form (the data is from a form?) before posting. Does the problem-layout output the dashes ok? Look at the html head for encoding info, compare to any encoding headers sent (using Firefox, Developer extension). Compare that to the working layout. Then work your way back towards the model. Check in the controller, then the Model. Hopefully you will find where thing do crazy. My guess is either in the initial output to the form, or in the post back to Cake. On Jul 9, 11:05 am, Ernesto <[email protected]> wrote: > i still haven't find a solution... > > i pr-ed $this->data in model::beforeSave. > > everything looks correct. > > this could be a MySQL-related issue :( > > On 8 Lug, 17:18, Ernesto <[email protected]> wrote: > > > > > this app is a very simple app. It is composed by a single controller, > > two layouts and 5 views. > > there's no app_controller or app_model and even no behaviors. > > i'm having this problem on the last 2 views, both using the second > > ("striptothebone") layout. > > The other 3 views are working fine. > > Every views saves one DateTime. > > > On 8 Lug, 16:48, Robert P <[email protected]> wrote: > > > > There are a lot of resulting steps between you passing in your data > > > and the resulting SQL being queried. Please provide some more > > > information and code examples. > > > > On Jul 8, 9:33 pm, Ernesto <[email protected]> wrote: > > > > > DateTime > > > > default = null > > > > null field > > > > > On 8 Lug, 15:20, Alastair <[email protected]> wrote: > > > > > > On Jul 8, 2:15 pm, Ernesto <[email protected]> wrote: > > > > > > > Hello. > > > > > > > i'm having some troubles with cake. > > > > > > > here's my this->data array > > > > > > > Array( > > > > > > [id] = 30 > > > > > > [date] = 2009-11-23 > > > > > > ) > > > > > > > here's a piece of my SQL dump > > > > > > > UPDATE `table` SET `id` = 30, `date` = '2009-11-23' WHERE > > > > > > `table`.`id` = 30 > > > > > > > why is cake de-coding the "-" in date??? > > > > > > Is the "date" field definitely a date or datetime type in your > > > > > database? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
