| # |
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 :) |
| # |
Sep 22nd 2011, 03:06 |
Section58 |
ACTION stretches |
| # |
Sep 22nd 2011, 03:03 |
NetersLandreau |
but looking at php docs, it will not work (the way you propose, anyway) "After this operator, an identifier is provided, then a newline".. still very ugly code |
| # |
Sep 22nd 2011, 02:58 |
NetersLandreau |
heredoc for sql? i don't know if it would work or not, but it sure is BUTT-UGLY |
| # |
Sep 22nd 2011, 02:48 |
friskd |
i'm refering in particular to the <<<MYSQL |
| # |
Sep 22nd 2011, 02:44 |
friskd |
so that you don't have to escape etc... |