| # |
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 |
| # |
Sep 21st 2011, 13:52 |
Section58 |
i am not happy with that contain |
| # |
Sep 21st 2011, 13:52 |
Section58 |
something like that |
| # |
Sep 21st 2011, 13:52 |
dakota |
Section58: school project? |
| # |
Sep 21st 2011, 13:49 |
carichardson |
I'm switching from php sessions to database sessions right now, created the cake_sessions in my database, updated the core.php file, but I don't see anything saving in cake_sessions table. Anybody know what I'm doing wrong? |
| # |
Sep 21st 2011, 13:49 |
Section58 |
it makes it look like i've ust installed a plugin and signed it off |
| # |
Sep 21st 2011, 13:48 |
92AAAG7K2 |
Anybody know if it's possible to login a user via a shell? ;) |
| # |
Sep 21st 2011, 13:48 |
Section58 |
i try and stay away from cakedc stuff as much as i can |
| # |
Sep 21st 2011, 13:48 |
Section58 |
yeah thanks |
| # |
Sep 21st 2011, 13:48 |
dakota |
Section58: you know, just something to look at for the future :) |
| # |
Sep 21st 2011, 13:48 |
dakota |
Section58: For you filtering, I'm going to point you back to my original suggestion. The CakeDC search plugin is fantastic for anything involving searching. It makes it incredibly easy to build up complex filters |