Re: Problem with cake and HTML encoding

2009-07-09 Thread Ernesto

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 e.fanz...@gmail.com 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 shiftyrobs...@gmail.com 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 e.fanz...@gmail.com wrote:

   DateTime
   default = null
   null field

   On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:

On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

2009-07-09 Thread Martin Westin

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 e.fanz...@gmail.com 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 e.fanz...@gmail.com 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 shiftyrobs...@gmail.com 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 e.fanz...@gmail.com wrote:

DateTime
default = null
null field

On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:

 On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

2009-07-09 Thread Ernesto

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 martin.westin...@gmail.com 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 e.fanz...@gmail.com 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 e.fanz...@gmail.com 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 shiftyrobs...@gmail.com 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 e.fanz...@gmail.com wrote:

 DateTime
 default = null
 null field

 On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:

  On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

2009-07-09 Thread Martin Westin

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 e.fanz...@gmail.com 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 martin.westin...@gmail.com 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 e.fanz...@gmail.com 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 e.fanz...@gmail.com 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 shiftyrobs...@gmail.com 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 e.fanz...@gmail.com wrote:

  DateTime
  default = null
  null field

  On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:

   On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

2009-07-09 Thread mehodgson

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 e.fanz...@gmail.com 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#45;11#45;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

2009-07-09 Thread Ernesto

Yes the data is being saved but with -00-00 00:00:00 value

On 9 Lug, 16:36, Martin Westin martin.westin...@gmail.com 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 e.fanz...@gmail.com 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 martin.westin...@gmail.com 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 e.fanz...@gmail.com 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 e.fanz...@gmail.com 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 shiftyrobs...@gmail.com 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 e.fanz...@gmail.com wrote:

   DateTime
   default = null
   null field

   On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:

On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

2009-07-09 Thread Ernesto

no, i'm not using sanitize

On 9 Lug, 17:01, mehodgson mehodg...@gmail.com 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 e.fanz...@gmail.com 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#45;11#45;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

2009-07-09 Thread Ernesto

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 e.fanz...@gmail.com wrote:
 Yes the data is being saved but with -00-00 00:00:00 value

 On 9 Lug, 16:36, Martin Westin martin.westin...@gmail.com 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 e.fanz...@gmail.com 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 martin.westin...@gmail.com 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 e.fanz...@gmail.com 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 e.fanz...@gmail.com 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 shiftyrobs...@gmail.com 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 e.fanz...@gmail.com wrote:

DateTime
default = null
null field

On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:

 On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

Problem with cake and HTML encoding

2009-07-08 Thread Ernesto

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#45;11#45;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

2009-07-08 Thread Alastair



On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

2009-07-08 Thread Ernesto

DateTime
default = null
null field

On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:
 On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

2009-07-08 Thread Robert P

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 e.fanz...@gmail.com wrote:
 DateTime
 default = null
 null field

 On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:

  On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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

2009-07-08 Thread Ernesto

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 shiftyrobs...@gmail.com 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 e.fanz...@gmail.com wrote:



  DateTime
  default = null
  null field

  On 8 Lug, 15:20, Alastair m...@alastairmoore.com wrote:

   On Jul 8, 2:15 pm, Ernesto e.fanz...@gmail.com 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#45;11#45;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
-~--~~~~--~~--~--~---