Re: [Catalyst] Cannot fetch value of Active pre-execute

2010-02-13 Thread Tomas Doran
On 13 Feb 2010, at 02:09, Silvio Almeida wrote: I got this error on script/myapp_server with DBI_TRACE=1 inside $c- authenticate call: - Cannot fetch value of Active pre-execute - prepare_cached('SELECT me.id, me.name, me.password, me.status, me.created, me.id_person

Re: [Catalyst] datetime formatting ...

2010-02-13 Thread Kiffin Gish
That worked, thanks. Only weird thing now is that the time is one hour behind. On Thu, 2010-02-11 at 12:45 -0300, Eden Cardim wrote: Kiffin == Kiffin Gish kiffin.g...@planet.nl writes: Kiffin I've got a datetime column defined: __PACKAGE__- add_columns( Kiffin ...

Re: [Catalyst] datetime formatting ...

2010-02-13 Thread Octavian Rasnita
From: Kiffin Gish kiffin.g...@planet.nl That worked, thanks. Only weird thing now is that the time is one hour behind. Use something like: -last_modified-set_time_zone('America/Chicago')-strftime('%F %T') Or add the time_zone parameter as an option in your Result class (after do not modify

Re: [Catalyst] datetime formatting ...

2010-02-13 Thread Kiffin Gish
Well actually I want to relate it to the timezone of the current user or if that is not set in the user preferences, the browser time. On Sat, 2010-02-13 at 23:09 +0200, Octavian Rasnita wrote: From: Kiffin Gish kiffin.g...@planet.nl That worked, thanks. Only weird thing now is that the time

Re: [Catalyst] datetime formatting ...

2010-02-13 Thread Octavian Rasnita
From: Kiffin Gish kiffin.g...@planet.nl Well actually I want to relate it to the timezone of the current user or if that is not set in the user preferences, the browser time. After you get the user time zone from users preferences, you can send it as a parameter to set_time_zone() method of

Re: [Catalyst] datetime formatting ...

2010-02-13 Thread Stuart Watt
On 2010-02-13, at 4:51 PM, Octavian Rasnita wrote: Don't know how to get the time zone of the user from browser, but I think it is not possible. You might need to get the visitor's IP and use a service that can tell you his/her country or even city, and maybe there is a module that can

Re: [Catalyst] datetime formatting ...

2010-02-13 Thread Kiffin Gish
Thanks. You're right about the timezone thing, I was confused with javascript and now realize that the tz is not passed via HTTP headers. Could save it in a cookie. Is $c-user-get(x) the same as $c-user-x ? mvg Kiffin On Sat, 2010-02-13 at 23:51 +0200, Octavian Rasnita wrote: From: Kiffin Gish

Re: [Catalyst] datetime formatting ...

2010-02-13 Thread Ben van Staveren
That's probably your database servers' time zone setting. If it's set to UTC you'd probably get that. You might want to add an 'on_connect_do' to your connection_info setting and execute the appropriate command to set the timezone you need (e.g. 'SET TIME ZONE LOCAL' or 'SET TIME ZONE

Re: [Catalyst] datetime formatting ...

2010-02-13 Thread Octavian Rasnita
From: Kiffin Gish kiffin.g...@planet.nl Thanks. You're right about the timezone thing, I was confused with javascript and now realize that the tz is not passed via HTTP headers. Could save it in a cookie. Is $c-user-get(x) the same as $c-user-x ? mvg Kiffin Yes it is the same thing if the