| # |
May 27th 2016, 21:41 |
phpcoder |
are you giving a talk ? |
| # |
May 27th 2016, 21:41 |
ionas |
its once a year |
| # |
May 27th 2016, 21:40 |
ionas |
but the workshops are over, conference is left for tomorrow and sunday |
| # |
May 27th 2016, 21:40 |
ionas |
I mean you â??still can" |
| # |
May 27th 2016, 21:40 |
ionas |
next time it is in europe you should |
| # |
May 27th 2016, 21:40 |
ionas |
oh, so you could have made it |
| # |
May 27th 2016, 21:40 |
phpcoder |
rome |
| # |
May 27th 2016, 21:40 |
phpcoder |
rom |
| # |
May 27th 2016, 21:39 |
ionas |
where you from? |
| # |
May 27th 2016, 21:39 |
ionas |
well the conferences are still up |
| # |
May 27th 2016, 21:39 |
ionas |
http://cakefest.org/ |
| # |
May 27th 2016, 21:39 |
ionas |
like yesterday, today etc |
| # |
May 27th 2016, 21:39 |
phpcoder |
passed ? |
| # |
May 27th 2016, 21:39 |
phpcoder |
when ? |
| # |
May 27th 2016, 21:38 |
ionas |
are you? |
| # |
May 27th 2016, 21:38 |
ionas |
phpcoder: how come you are not at cakefest |
| # |
May 27th 2016, 21:38 |
phpcoder |
thanksù |
| # |
May 27th 2016, 21:38 |
phpcoder |
ok! |
| # |
May 27th 2016, 21:38 |
phpcoder |
yes |
| # |
May 27th 2016, 21:38 |
ionas |
however Iâ??d probabably build a finder and then put hydrate false and formatresults into another method that is non-chainable (no finder) because stuff stops there ;) |
| # |
May 27th 2016, 21:37 |
ionas |
to transform the result to just one single number |
| # |
May 27th 2016, 21:37 |
phpcoder |
i got it! thanks!! |
| # |
May 27th 2016, 21:37 |
ionas |
you can probably also use formatresults |
| # |
May 27th 2016, 21:37 |
phpcoder |
aah ok |
| # |
May 27th 2016, 21:36 |
phpcoder |
let me see |
| # |
May 27th 2016, 21:36 |
ionas |
and then donâ??t use ->count() |
| # |
May 27th 2016, 21:36 |
ionas |
http://book.cakephp.org/3.0/en/orm/query-builder.html#using-sql-functions |
| # |
May 27th 2016, 21:35 |
ionas |
http://book.cakephp.org/3.0/en/orm/query-builder.html#getting-arrays-instead-of-entities |
| # |
May 27th 2016, 21:34 |
phpcoder |
(tested on workbench) |
| # |
May 27th 2016, 21:34 |
phpcoder |
i will post you the query that works |
| # |
May 27th 2016, 21:34 |
phpcoder |
one moment |
| # |
May 27th 2016, 21:32 |
ionas |
like whats the php code |
| # |
May 27th 2016, 21:31 |
ionas |
is that the query you already have? or the query you get when running â??countâ?? |
| # |
May 27th 2016, 21:30 |
phpcoder |
ionas, if i add -count() it execytes the query...i have to find how to disable this execution |
| # |
May 27th 2016, 21:29 |
ionas |
count on a subquery :)? |
| # |
May 27th 2016, 21:28 |
ionas |
Iâ??d check if you can disable auto-execution on first, all, count etc |
| # |
May 27th 2016, 21:28 |
phpcoder |
ionas https://gist.github.com/anonymous/08a079d90a3fcf85f58705c1aca298a2#file-gistfile1-txt-L4-L9 |
| # |
May 27th 2016, 21:28 |
ionas |
(later on) |
| # |
May 27th 2016, 21:28 |
ionas |
phpcoder: SELECT count(*) FROM fooâ?¦ maybe you can use select() with a custom expression and use hydrate(false) |
| # |
May 27th 2016, 21:22 |
phpcoder |
i read ->count() execute the query and returns the number of records |
| # |
May 27th 2016, 21:21 |
phpcoder |
without executing the quesry? |