THANK you so much! I tried that approach before but got some weird errors so dismissed it without trying any further.. this way it works perfectly!
thanks again On Jul 4, 6:00 pm, majna <[email protected]> wrote: > Using AppModel constructor works for me: > > function __construct($id = null, $table = null, $ds = null) > { > parent::__construct($id, $table, $ds); > if (!defined('GLOBAL_ZONE_SET') && $this->useTable !== false) > { > $this->execute("SET GLOBAL time_zone = ‘+2:00′'"); > define('GLOBAL_ZONE_SET', true); > } > } > > On Jul 4, 4:31 pm, ark0n3 <[email protected]> wrote: > > > > > > > > > Hi everyone > > I'm going crazy for such a trivial matter. I need to run a one-time > > query at the beginning of the connection to the mysql server (SET > > GLOBAL time_zone = ‘+2:00′) but can't figure out where I need to put > > the code in the cake codebase. > > > Many thanks in advance to whoever will help me fix this. > > > ps i already tried in the contructor of app_model.php but got not luck > > with cake 1.2.10 -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
