Re: Another HABTM issue : row with same Id getting over-written

Well, assuming the Docs are correct (and I understand it properly),
that should only apply to updates ("If true (default value) cake will
first delete existing relationship records in the foreign keys table
before inserting new ones, when updating a record. So existing
associations need to be passed again when updating").

However, in my circumstance, I'm just retrieving information ...

Debug SQL shows the (as expected) query of getting all webpages &
types based on the user_id, and it retrieves all the information
that's needed; however, by the time I get to the view (where I have a
`pr()`), I've magically lost one of 'em - well, actually, any
subsequent webpage_type record that has the same id.

Conventions: Yeah, I know those were just there, left over from
scaffolding, so figured no harm in leaving 'em ...

On Oct 3, 3:19 pm, teknoid <teknoid.cake...@gmail.com> wrote:
> Do you know what 'unique'=>true does?
>
> Btw, there really isn't any need to define default values for your
> associations if you follow the conventions.
>
> On Oct 3, 6:10 pm, Brenton B <brenton.bar...@gmail.com> wrote:
>
> > Ok, so here's the scenario ...
>
> > A user can have multiple webpages in their account, and when they set
> > them up, they must choose the type (ex: blog, gallery, etc). So User
> > HABTM webpage_type ... where users_webpage_types has additional fields
> > for URL, title, etc.
>
> > The thing I'm running into is upon retrieving: If an user has 2 of the
> > same webpage_type, it performs the SQL to get 'em all, but once it's
> > done it's magic, it only has the first record. I'm assuming this is
> > due to the occurrence of the same webpage_type_id, but still lost ...
>
> > User::
>
> > var $hasAndBelongsToMany = array(
> > 'WebpageType' => array('className' => 'WebpageType',
> > 'joinTable' => 'users_webpage_types',
> > 'foreignKey' => 'userr_id',
> > 'associationForeignKey' => 'webpage_type_id',
> > 'with' => 'UsersWebpageType',
> > 'unique' => true,
> > ),
>
> > WebpageType::
>
> > var $hasAndBelongsToMany = array(
> > 'User' => array('className' => 'User',
> > 'joinTable' => 'users_webpage_types',
> > 'foreignKey' => 'webpage_type_id',
> > 'associationForeignKey' => 'user_id',
> > 'with' => 'UsersWebpageType',
> > 'unique' => true,
>
> > UsersWebpageType::
>
> > var $belongsTo = array(
> > 'User' => array('className' => 'User',
> > 'foreignKey' => 'user_id',
> > 'conditions' => '',
> > 'fields' => '',
> > 'order' => ''
> > ),
> > 'WebpageType' => array('className' => 'WebpageType',
> > 'foreignKey' => 'webpage_type_id',
> > 'conditions' => '',
> > 'fields' => '',
> > 'order' => ''
> > )
> > );
>
> > Seriously confused ....
>
> > I've searched the group, and came up empty handed - probably due to
> > diff keywords.
>
> > Cheers.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---