Re: Problem with cake and HTML encoding
Hurray
everything's working!!!
i changed the entire DB charset/collations to UTF-8 and added
"defaultCharSet = UTF-8" to my PHP.ini
tonight i'll be veeery drunk :)
On 9 Lug, 17:07, Ernesto wrote:
> Yes the data is being saved but with "-00-00 00:00:00" value
>
> On 9 Lug, 16:36, Martin Westin wrote:
>
>
>
> > Then Cake might be trying to save utf8 to the "latin" database and
> > converting the data for you at some stage.
>
> > Come to think of it... is the problematic data being saved to the db?
> > Can you check the contents of the database directly?
> > Cake might be converting the encoding at the output of the dump.
>
> > As a rule, when you have the db, Cake or the html set to a different
> > character encoding than the others you will see strange things with
> > non-latin characters. (then again, the minus-sign should be generic
> > enough to pass untouched).
>
> > Sorry, just ramblings. I havent investigated the details. I just
> > figured I'd better set everything to the same encoding to avoid
> > further problems (and oh boy did I have problems at one point).
>
> > On Jul 9, 3:02 pm, Ernesto wrote:
>
> > > 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 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 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 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 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 wrote:
>
> > > > > > > > DateTime
> > > > > > > > default = null
> > > > > > > > null field
>
> > > > > > > > On 8 Lug, 15:20, Alastair wrote:
>
> > > > > > > > > On Jul 8, 2:15 pm, Ernesto 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 subscr
Re: Problem with cake and HTML encoding
no, i'm not using sanitize On 9 Lug, 17:01, mehodgson wrote: > Are you using the Sanitize component on your data? If you are you and > you use the clean() function you may need to set encode=false. > > On Jul 8, 6:15 am, Ernesto 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??? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
Yes the data is being saved but with "-00-00 00:00:00" value
On 9 Lug, 16:36, Martin Westin wrote:
> Then Cake might be trying to save utf8 to the "latin" database and
> converting the data for you at some stage.
>
> Come to think of it... is the problematic data being saved to the db?
> Can you check the contents of the database directly?
> Cake might be converting the encoding at the output of the dump.
>
> As a rule, when you have the db, Cake or the html set to a different
> character encoding than the others you will see strange things with
> non-latin characters. (then again, the minus-sign should be generic
> enough to pass untouched).
>
> Sorry, just ramblings. I havent investigated the details. I just
> figured I'd better set everything to the same encoding to avoid
> further problems (and oh boy did I have problems at one point).
>
> On Jul 9, 3:02 pm, Ernesto wrote:
>
>
>
> > 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 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 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 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 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 wrote:
>
> > > > > > > DateTime
> > > > > > > default = null
> > > > > > > null field
>
> > > > > > > On 8 Lug, 15:20, Alastair wrote:
>
> > > > > > > > On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
Are you using the Sanitize component on your data? If you are you and you use the clean() function you may need to set encode=false. On Jul 8, 6:15 am, Ernesto 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??? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
Then Cake might be trying to save utf8 to the "latin" database and
converting the data for you at some stage.
Come to think of it... is the problematic data being saved to the db?
Can you check the contents of the database directly?
Cake might be converting the encoding at the output of the dump.
As a rule, when you have the db, Cake or the html set to a different
character encoding than the others you will see strange things with
non-latin characters. (then again, the minus-sign should be generic
enough to pass untouched).
Sorry, just ramblings. I havent investigated the details. I just
figured I'd better set everything to the same encoding to avoid
further problems (and oh boy did I have problems at one point).
On Jul 9, 3:02 pm, Ernesto wrote:
> 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 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 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 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 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 wrote:
>
> > > > > > DateTime
> > > > > > default = null
> > > > > > null field
>
> > > > > > On 8 Lug, 15:20, Alastair wrote:
>
> > > > > > > On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
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 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 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 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 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 wrote:
>
> > > > > DateTime
> > > > > default = null
> > > > > null field
>
> > > > > On 8 Lug, 15:20, Alastair wrote:
>
> > > > > > On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
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 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 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 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 wrote:
>
> > > > DateTime
> > > > default = null
> > > > null field
>
> > > > On 8 Lug, 15:20, Alastair wrote:
>
> > > > > On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
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 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 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 wrote:
>
> > > DateTime
> > > default = null
> > > null field
>
> > > On 8 Lug, 15:20, Alastair wrote:
>
> > > > On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
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 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 wrote:
>
>
>
> > DateTime
> > default = null
> > null field
>
> > On 8 Lug, 15:20, Alastair wrote:
>
> > > On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
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 wrote: > DateTime > default = null > null field > > On 8 Lug, 15:20, Alastair wrote: > > > On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
DateTime default = null null field On 8 Lug, 15:20, Alastair wrote: > On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Problem with cake and HTML encoding
On Jul 8, 2:15 pm, Ernesto 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 cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
