to work in that way. Normally, in a non CakePHP enviroment, a
joinTable has the 2 foreign keys and they set as the "primary key"
column. You don´t have the "id" column that CakePHP expects to have
and then the foreign keys... thats why the "uniqueness" of the
records.
Personally i would change the schema of you database for something
like
users
web_pages (holding the url, title, etc)
web_page_types (holding the name of the webpage type)
And the associations
user hasMany webpages
webpage belongsTo user
webpage belongsTo webpageType
On Oct 3, 6:37 pm, teknoid <teknoid.cake...@gmail.com> wrote:
> Goes to show I should read more carefully :)
> I guess the title of the post made me jump the gun...
>
> You say "an user has 2 of the same webpage_type"
>
> Does it mean that in your join table you have something like: ?
> user_id | web_page_type_id
> -----------------------------------------
> 7 | 6
> 7 | 6
>
> On Oct 3, 6:27 pm, Brenton B <brenton.bar...@gmail.com> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
No comments:
Post a Comment