| # |
Sep 21st 2011, 14:03 |
Ghost_Trolley |
good afternoon, btw ;) |
| # |
Sep 21st 2011, 14:03 |
Ghost_Trolley |
Yo section58, is there an easy way to display text next to a field ('please enter a postcode') when its left blank? |
| # |
Sep 21st 2011, 14:03 |
Section58 |
and this was my attempt of making it work better |
| # |
Sep 21st 2011, 14:02 |
Section58 |
to a complex mess that makes no sence |
| # |
Sep 21st 2011, 14:02 |
Section58 |
its been the same query slowly building up |
| # |
Sep 21st 2011, 14:02 |
Section58 |
and no |
| # |
Sep 21st 2011, 14:02 |
Section58 |
NetersLandreau: it does work .. |
| # |
Sep 21st 2011, 14:02 |
Section58 |
somehow get joins working after its done the containable magic for the other filters |
| # |
Sep 21st 2011, 14:02 |
NetersLandreau |
Section58: you've been battling this for a few days.. perhaps you may just want to make it work and then make it work better? |
| # |
Sep 21st 2011, 14:01 |
Section58 |
its like i wanna do a mini query inside a query |
| # |
Sep 21st 2011, 14:01 |
Section58 |
i guess i would have to drop contains for joins. |
| # |
Sep 21st 2011, 14:01 |
Section58 |
it needs a lot of tcl, i don't wanna be making it slower with poor querys |
| # |
Sep 21st 2011, 14:00 |
Section58 |
this whole site app is wack |
| # |
Sep 21st 2011, 14:00 |
TehTreag |
) |
| # |
Sep 21st 2011, 14:00 |
dakota |
I use joins quite often in some projects. Sometimes relations are just too complex to do any other way |
| # |
Sep 21st 2011, 14:00 |
dakota |
TehTreag: likewise. but it isn't as clean as 'contains' => array('TutorialView') |
| # |
Sep 21st 2011, 13:59 |
TehTreag |
dakota: Looks nice enough to me. |
| # |
Sep 21st 2011, 13:59 |
TehTreag |
http://bin.cakephp.org/view/756877933 |
| # |
Sep 21st 2011, 13:58 |
dakota |
the joins syntax isn't as clean as what you'd probably like, but it works :) |
| # |
Sep 21st 2011, 13:58 |
dakota |
Section58: http://book.cakephp.org/view/1047/Joining-tables |
| # |
Sep 21st 2011, 13:58 |
Section58 |
i am happy to make lots of spag code if it tidys the querys to something less than 25 |
| # |
Sep 21st 2011, 13:57 |
dakota |
Section58: but you can do it with 'ad-hoc joins' |
| # |
Sep 21st 2011, 13:57 |
Section58 |
Are you interjecting again? |
| # |
Sep 21st 2011, 13:57 |
dakota |
Section58: you can't really (Without doing some extra binds) |
| # |
Sep 21st 2011, 13:57 |
Section58 |
TehTreag: ? |
| # |
Sep 21st 2011, 13:57 |
Section58 |
yeah that sql is what i thought i wanted, how to make that in contain is over my head |
| # |
Sep 21st 2011, 13:57 |
TehTreag |
~tell Section58 about relations |
| # |
Sep 21st 2011, 13:57 |
Section58 |
strange way of doing that |
| # |
Sep 21st 2011, 13:57 |
Section58 |
i think so, just worked that out |
| # |
Sep 21st 2011, 13:56 |
dakota |
so event belongsTo Venue? |
| # |
Sep 21st 2011, 13:56 |
Section58 |
no. not for this system |
| # |
Sep 21st 2011, 13:55 |
dakota |
can a event have more than one venue? |
| # |
Sep 21st 2011, 13:55 |
dakota |
hope that makes sense |
| # |
Sep 21st 2011, 13:55 |
dakota |
Section58: I would write a query something like: select from artists join artistsevents on (artistsevents.artist_id = artist.id) join events (events.id = artistsevents.event_id AND start_date >= currentDate) join eventsvenue on (...) join venues (venues.id = eventsvenue.venue_id) group by artists.id order events.start_date asc |
| # |
Sep 21st 2011, 13:55 |
Section58 |
if they were bto's or hasmans then it would just link in one line :) |
| # |
Sep 21st 2011, 13:54 |
Section58 |
that fact its 2 distant habtm's is why its so hard |
| # |
Sep 21st 2011, 13:53 |
Section58 |
it might not search itself 20 times |
| # |
Sep 21st 2011, 13:53 |
Section58 |
maybe if i could somehow make Events hasone Venues |
| # |
Sep 21st 2011, 13:53 |
dakota |
Section58: it's good for 95% of queries. Complex stuff like this is kinda falls over on |
| # |
Sep 21st 2011, 13:53 |
Section58 |
i don't think i wanna use it anymore |
| # |
Sep 21st 2011, 13:52 |
Section58 |
if its really naturyally like that |