Does this allow me to update the join-table, also the columns that are
not really part of the HABTM association?
Also, at the moment I solved this using the Has Many --> Belongs to
<-- Has many method. The solution was to use the recursive variable.
thanks for the help so far.
On Jun 20, 1:59 pm, Joshua Benner <[EMAIL PROTECTED]> wrote:
> I did something similar, where 'faculty' has and belongs to many
> 'activity' and each link has a student count associated with it -- I
> used a custom finderQuery in the definition of the association to pull
> the student count field with all the other data (TSQL, so some minor
> differences from MySQL, and this works with cake 1.2):
>
> var $hasAndBelongsToMany = array(
> 'Activity' => array('className' => 'Activity',
> 'joinTable' => 'activity_links',
> 'foreignKey' => 'faculty_id',
> 'associationForeignKey' => 'activity_id',
> 'unique' => true,
> 'finderQuery' => '
> SELECT
> [Activity].[id] as [Activity.id],
> [Activity].[name] as [Activity.name],
> [Activity].[activity_type_id] as [Activity.activity_type_id],
> [Activity].[credits] as [Activity.credits],
> [ActivityLink].[students] as [Activity.students],
> [ActivityLink].[id] as [Activity.activity_link_id]
> FROM
> [activities] AS [Activity]
> JOIN [activity_links] AS [ActivityLink] ON [ActivityLink].
> [activity_id] = [Activity].[id]
> WHERE
> [ActivityLink].[faculty_id] = {$__cakeID__$}
> ORDER BY
> [Activity].[name] ASC'
> )
>
> On Jun 20, 6:03 am, BoSc <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > I have three tables:
>
> > cities
> > categories
> > categories_cities
>
> > The first two are normal tables, the third one is used for linking.
> > Since I want to be able to indicate if the link is active, I've added
> > a column active to the categories_cities table. Using HABTM I am not
> > able to access any data of the categories-cities table caus it's used
> > for linking only. Is there any way to do make this work?
>
> > I've considered using the Has Many, Belongs to method, but in someway,
> > using the findAll method doesn't return data in a deep enough
> > recursive way.
>
> > Any thoughts?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
