| # |
Sep 22nd 2011, 05:12 |
Section58 |
having an output of what the sql is doing is rather helpful |
| # |
Sep 22nd 2011, 05:10 |
Section58 |
or the sql_log ? |
| # |
Sep 22nd 2011, 05:10 |
Section58 |
youer not using debug kit |
| # |
Sep 22nd 2011, 05:09 |
Heshanh |
hm, how do u print the last sql that was executed? |
| # |
Sep 22nd 2011, 05:07 |
Heshanh |
ah! thanks :) |
| # |
Sep 22nd 2011, 05:06 |
Section58 |
its at the bottom |
| # |
Sep 22nd 2011, 05:06 |
Section58 |
Heshanh: complex finds in the book man |
| # |
Sep 22nd 2011, 05:05 |
ddoom |
stupid hiddenfields |
| # |
Sep 22nd 2011, 05:05 |
ddoom |
hurrah is all right in the world |
| # |
Sep 22nd 2011, 05:05 |
Heshanh |
like where client =3 OR cleint= 0 |
| # |
Sep 22nd 2011, 05:05 |
Heshanh |
when u define the condtions in ->find how do u set a a OR condition |
| # |
Sep 22nd 2011, 04:44 |
Section58 |
have a good night o/ |
| # |
Sep 22nd 2011, 04:43 |
Section58 |
fingers crossed i don't have to change the views loads |
| # |
Sep 22nd 2011, 04:43 |
Section58 |
i have no idea how cake will impliment the result into the data arry tho |
| # |
Sep 22nd 2011, 04:43 |
Section58 |
and as a bonus, useing contains has givin me some very good examples of what the query should look like |
| # |
Sep 22nd 2011, 04:42 |
Section58 |
its my problem i need to fix |
| # |
Sep 22nd 2011, 04:42 |
Section58 |
you have been awesome |
| # |
Sep 22nd 2011, 04:40 |
NetersLandreau |
i wish you the best in your search, but my eyes are getting blurry so i need to go to bed |
| # |
Sep 22nd 2011, 04:38 |
Section58 |
excuse the pun |
| # |
Sep 22nd 2011, 04:38 |
Section58 |
should beable to be the iceing on the cake |
| # |
Sep 22nd 2011, 04:38 |
Section58 |
will google around for some hardcore join examples |
| # |
Sep 22nd 2011, 04:37 |
Section58 |
i think, sort of, i wanna use joins for my events/venue results and somehow still use contain for the filtering |
| # |
Sep 22nd 2011, 04:37 |
NetersLandreau |
but i think you are on the right track when you say to scuttle containable |
| # |
Sep 22nd 2011, 04:36 |
Section58 |
i can't be too far off, and this query is already 35 lines of time and learning |
| # |
Sep 22nd 2011, 04:36 |
Section58 |
yeah, thats what i was thinking |
| # |
Sep 22nd 2011, 04:36 |
Section58 |
i guess its not possible to do a habtm lookup in one query |
| # |
Sep 22nd 2011, 04:36 |
NetersLandreau |
i think you are so deep into this that to try and use some third-party code/plugin would only be distracting at this point, tbh |
| # |
Sep 22nd 2011, 04:35 |
Section58 |
or i will never advance with cake |
| # |
Sep 22nd 2011, 04:35 |
Section58 |
i can have a look at it, but i have been trying to make my own stuff recently |
| # |
Sep 22nd 2011, 04:34 |
Section58 |
still havn't worked out habtm joins tho |
| # |
Sep 22nd 2011, 04:34 |
NetersLandreau |
you can do a lot with cakedc's searchable plugin.. i was able to get to perform some pretty miraculous finds with it |
| # |
Sep 22nd 2011, 04:34 |
Section58 |
then the sql produced could be near perfection |
| # |
Sep 22nd 2011, 04:34 |
Section58 |
if i am able to split joins in a if (for filtering) |
| # |
Sep 22nd 2011, 04:32 |
Section58 |
not enough |
| # |
Sep 22nd 2011, 04:32 |
Section58 |
) |
| # |
Sep 22nd 2011, 04:32 |
Section58 |
but i would asume that used containble as well |
| # |
Sep 22nd 2011, 04:32 |
NetersLandreau |
have you been drinking? your speech is slurred ;) |
| # |
Sep 22nd 2011, 04:32 |
Section58 |
another sujest was to installed the cakedc searchable plugin |
| # |
Sep 22nd 2011, 04:31 |
Section58 |
its ust preinitble, as its ment to be my job to improve the app, not make it slower |
| # |
Sep 22nd 2011, 04:31 |
Section58 |
technicly, i could pretend it doesn't make those 25 querys on the end, i now it would cache the first one anyway |
| # |
Sep 22nd 2011, 04:30 |
NetersLandreau |
yep |