Hi Martin.
i really appreciated your hints.
here's my findings
- I coded an "echo '----';" in the non-working layout --> the dashes
are correctly printed.
- I coded another "echo '----';" in one of the non-working views -->
the dashed are still correctly printed
- The data is auto-filled by the controller, this app has no forms
- all 5 views are using the same DB Connection and the same Database
- the SQL Connection, the DB and all the DB's tables have the same
collation ("latin1_swedish_ci")
- all the DateTime fields has no collation selected
- Cake app has UTF-8 encoding
the problem is still here :(
On 9 Lug, 11:54, Martin Westin <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
