Any HABTM guru out there, please I need to be enlightned.
There are 3 tables and their models :
Equipment (id, name, ...)
Expenses (id, name, ...)
Equipment_Expenses (equipment_id, expense_id)
I want to establish a HABTM relation between equipment a expenses
(many expenses 'hanging' from a equipment)
this is my 'baked' Equipment model:
var $hasAndBelongsToMany = array(
'Expense' => array('className' => 'Expense',
'joinTable' =>
'equipment_expenses',
'foreignKey' => 'equipment_id',
'associationForeignKey' =>
'expense_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
)
);
I also 'baked' the controller and standard views. When I see an
Equipment entry, the Expense array is empty despite the tables are
populated.
The SQL query that cakephp generates is:
SELECT `Expense`.`id`, `Expense`.`expense_type_id`, `Expense`.`name`,
`Expense`.`desc`, `Expense`.`spent_on`, `Expense`.`ammount`,
`Expense`.`ammount_back`, `EquipmentExpense`.`equipment_id`,
`EquipmentExpense`.`expense_id` FROM `expenses` AS `Expense` JOIN
`equipment_expenses` AS `EquipmentExpense` ON
(`EquipmentExpense`.`equipment_id` = 1 AND
`EquipmentExpense`.`expense_id` = `Expense`.`id`) WHERE 1 = 1
Please note `EquipmentExpense`.`equipment_id` = 1 is the id for the
equipment entry I want to see
running this query in mysql also returns empty records.
The only similar post I found on the group was this one, tried
everything on that post but doesn't help
http://groups.google.com/group/cake-php/browse_thread/thread/a6e7780e54d339c3/658026c417cc8423?lnk=gst&;
This is a very basic HABTM structure, why is not working?
Any help will be very much appreciated. Thanks
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
