The query actually looks ok to me ... in what way are the results incorrect ?
On Tue, Sep 29, 2009 at 8:55 PM, bram <[email protected]> wrote: > > These are the resulting queries: > > SELECT `User`.`id`, `User`.`username`, `User`.`name` FROM `users` AS > `User` ORDER BY `name` ASC > > SELECT `Event`.`id`, `Event`.`date`, `EventsUser`.`id`, > `EventsUser`.`event_id`, `EventsUser`.`user_id` FROM `events` AS > `Event` JOIN `events_users` AS `EventsUser` ON (`EventsUser`.`user_id` > IN (3, 1, 2) AND `EventsUser`.`event_id` = `Event`.`id`) WHERE 1 = 1 > ORDER BY `Event`.`date` DESC LIMIT 1 > > I actually don't know how to rewrite this query to get the latest > associated event (one) for each user... > > > On Sep 29, 3:30 pm, Bert Van den Brande <[email protected]> wrote: > > Have a look at the query it generates (set debug to 2) , I'm sure this > will > > shine a bright light on the problem ... > > > > On Mon, Sep 28, 2009 at 9:48 PM, bram <[email protected]> wrote: > > > > > In my app, I have a User model that has a habtm association with > > > 'Event'. In one of the views, I want to show a list of Users and their > > > most recent event. > > > > > I ended up with this definition in the User model: > > > > > var $hasAndBelongsToMany = array( > > > 'Event' => array( > > > 'className' => 'Event', > > > 'joinTable' => 'events_users', > > > 'foreignKey' => 'user_id', > > > 'associationForeignKey' => 'event_id', > > > 'unique' => true, > > > 'limit' => 1, > > > 'order' => 'Event.date DESC' > > > ) > > > ); > > > > > find('all') returns the list of all users and only one of them has an > > > associated event. > > > > > When increasing the limit, it does show associated events, but when > > > some user don't have events associated, some other users will have > > > multiple events returned. > > > > > Is this a cake bug or do I have the wrong impression of the limit in a > > > habtm association? > > > > > Cheers, > > > > > Bram > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
