Log message #2299137

# At Username Text
# Sep 22nd 2011, 04:05 cpgo hmm thats differnet, probably it
# Sep 22nd 2011, 04:04 cpgo yea haha
# Sep 22nd 2011, 04:04 Seguer oh yeah i removed it
# Sep 22nd 2011, 04:04 Seguer ~cpgo
# Sep 22nd 2011, 04:04 cpgo cpgo is cpslow
# Sep 22nd 2011, 04:04 Seguer i have been doing that a lot these days :<
# Sep 22nd 2011, 04:04 cpgo remember
# Sep 22nd 2011, 04:04 cpgo yes lol
# Sep 22nd 2011, 04:04 Seguer cpgo: to tell you things you should already know? :P
# Sep 22nd 2011, 04:03 cpgo ah so that's why we keep you around
# Sep 22nd 2011, 04:03 Seguer cpgo: check tests?
# Sep 22nd 2011, 04:02 Seguer friskd: does it start transaction and rollback if you do a normal ->find()?
# Sep 22nd 2011, 04:02 cpgo can anyone else confirm cake 2.0 contain in pagination calls do not work
# Sep 22nd 2011, 04:02 Seguer friskd: what was the original select you were trying to do?
# Sep 22nd 2011, 04:02 Seguer friskd: normally transactions surround stuff that has an effect on the db (ie, delete/update)
# Sep 22nd 2011, 04:02 Seguer friskd: probably because the driver doesn't realise you are doing a select, and its checking for something that the select query doesn't return
# Sep 22nd 2011, 04:01 friskd ROLLBACK
# Sep 22nd 2011, 04:01 friskd Select * from users;
# Sep 22nd 2011, 04:01 friskd i see Start Transaction
# Sep 22nd 2011, 04:01 friskd So when i run it
# Sep 22nd 2011, 04:01 friskd Seguer: i need to raw sql for something... and i have simplified it down to this select statement to debug
# Sep 22nd 2011, 04:00 Seguer friskd: why are you running raw sql anyway
# Sep 22nd 2011, 04:00 friskd if i look in the query log i see
# Sep 22nd 2011, 04:00 friskd So for some reason when i run $this->Model->query('Select * from users");
# Sep 22nd 2011, 04:00 NetersLandreau friskd: what do you mean it is doing a roll-back on a select?
# Sep 22nd 2011, 03:54 NetersLandreau ddoom: yes it is possible - http://book.cakephp.org/view/1395/options-multiple
# Sep 22nd 2011, 03:51 NetersLandreau hi CSdread_
# Sep 22nd 2011, 03:51 cpgo $this->paginate['contain'] = array('Term', 'Department', 'Professor'); // it doesnt contain these
# Sep 22nd 2011, 03:50 NetersLandreau lemme guess Section58, table joins?
# Sep 22nd 2011, 03:50 cpgo in 2.0
# Sep 22nd 2011, 03:50 cpgo has the way contain in pagination calls changed?
# Sep 22nd 2011, 03:41 friskd i am just doing a select * in the query and cake is auto rolling back
# Sep 22nd 2011, 03:40 friskd if the query is successful
# Sep 22nd 2011, 03:40 friskd What might cause $this->Query to auto rollback
# Sep 22nd 2011, 03:40 friskd thanks NetersLandreau
# Sep 22nd 2011, 03:40 friskd it was heredoc
# Sep 22nd 2011, 03:34 ddoom is it possible to create a multiselect checkbox field using teh form helper?
# Sep 22nd 2011, 03:09 Section58 *time
# Sep 22nd 2011, 03:08 Section58 have i set some sort of passtie
# Sep 22nd 2011, 03:07 CSdread_ hi NetersLandreau
# Sep 22nd 2011, 03:06 Section58 hey NetersLandreau guess what query i am doing :)