Okey, i have done that know.
Though im getting a SQL error that is shouldn't get:
Warning (512): SQL Error: 1054: Unknown column 'EventsUsers.user_id'
in 'where clause' [CORE\cake\libs\model\datasources\dbo_source.php,
line 514]
Query: SELECT `Event`.`id`, `Event`.`user_id`, `Event`.`title` FROM
`events` AS `Event` WHERE `EventsUsers`.`user_id` = 12
This is using this code in my controller:
$this->set('events', $this->Event->find('all', array(
'conditions'=>array('EventsUsers.user_id'=>'12')
)));
the user HABTM Events. though i kept the Event.user_id.
Events are similiar to "ToDo-notes". I want to create my own todo's
like "buy the newspaper". But my roomate might just share me a event/
note that says "Buy Milk!".
buy the newspaper shouldn't be in the EventUser table while "Buy Milk"
should. And then i still need Event.user_id.
btw: I dont have a model for EventUser, do i need one?
On 7 Feb, 11:11, WebbedIT <[email protected]> wrote:
> First things first, your relationships are a bit mixed up ... both
> models should HABTM each other, you're confusing things by trying to
> create User hasMany Event. Remove users_id from events table, specify
> that User HABTM Event and rely on the join table to relate things.
>
> Not sure why mscdex advises removing the id field from the join table,
> I include one in all my join tables without issue, but happy for
> mscdex to elaborate and inform us of some performance improvement that
> may cause :)
>
> Onto your question about the data fetched by your find call. When
> everything is linked by HABTM you can do the following find
>
> $this->Event->find('all', array(
> 'conditions'=>array('EventsUsers.user_id'=>'12')
> ));
>
> It's the confusion of relating users to events in two different ways
> which makes your query difficult .. once you link them by HABTM alone
> it becomes easy.
>
> Paul.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
