I update the extra fields in the link table with a separate model from
the controller methods (add/edit/delete, etc).
BoSc wrote:
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?
--
Joshua Benner
http://bennerweb.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
|
