| # |
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... |
| # |
Sep 22nd 2011, 02:44 |
friskd |
Has anyone ever used this : $this->Model->query( <<<MYSQL some sql query MYSQL): |
| # |
Sep 22nd 2011, 02:12 |
markstory |
) |
| # |
Sep 22nd 2011, 02:10 |
mdunham918_ |
2.0 is so much prettier than 1.3 |
| # |
Sep 22nd 2011, 02:10 |
mdunham918_ |
i've through almost every line of source code in 1.3 and 2.0 pre rc1 |
| # |
Sep 22nd 2011, 02:09 |
mdunham918_ |
its almost like jQuery on a html site to me |
| # |
Sep 22nd 2011, 02:08 |
mdunham918_ |
yes, indeed they do. |
| # |
Sep 22nd 2011, 02:08 |
mdunham918_ |
were talking about database apps on a html site no way but anything with a database backend i use cake its just too convenient you'll end up writing the same code over and over |
| # |
Sep 22nd 2011, 02:08 |
markstory |
they always start small and grow into an insane mess. |