# |
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 |
# |
Sep 22nd 2011, 04:30 |
Section58 |
i am logically guessing that the way to fix would be to drop the use of contain and use joins for all the relations and matches |
# |
Sep 22nd 2011, 04:29 |
ddoom |
I figured out how to print each radio button separately. But now i'm getting a hidden field before each radio button, and it looks like it has the same name so its overriding the values |
# |
Sep 22nd 2011, 04:29 |
Section58 |
its the event/venue part that makes it all werid |
# |
Sep 22nd 2011, 04:29 |
Section58 |
on the artists controller, they wanna have a paginated list filtered by genre and country.. with the additional infomation about 'Artist next playing in at Event/Venue' in the results |
# |
Sep 22nd 2011, 04:27 |
Section58 |
and my mind was blank |
# |
Sep 22nd 2011, 04:26 |
Section58 |
i just tryed to think of it now |
# |
Sep 22nd 2011, 04:26 |
Section58 |
more than one, cause it would use values from the first |
# |
Sep 22nd 2011, 04:26 |
Section58 |
unknown |