I have created 3 tables: pages, sections, page_sections. All naming
conventions aside, the findAll() query returns
Array
(
[0] => Array
(
[SECTION] => Array
(
[ID] => 4
[ACCOUNT_ID] => 5000
[NAME] => accounting
[STANDARD] => 1
[VISIBLE] => 1
[DISPLAY_NAME] => Accounting
)
)
[1] => Array
(
[SECTION] => Array
(
[ID] => 3
[ACCOUNT_ID] => 5000
[NAME] => project
[STANDARD] => 1
[VISIBLE] => 1
[DISPLAY_NAME] => Project
)
)
[2] => Array
(
[SECTION] => Array
(
[ID] => 2
[ACCOUNT_ID] => 5000
[NAME] => contacts
[STANDARD] => 1
[VISIBLE] => 1
[DISPLAY_NAME] => Contacts
)
)
[3] => Array
(
[SECTION] => Array
(
[ID] => 1
[ACCOUNT_ID] => 5000
[NAME] => request
[STANDARD] => 1
[VISIBLE] => 1
[DISPLAY_NAME] => Request
)
)
)
The $habtm looks like this:
var $hasAndBelongsToMany = array('Section' =>
array('className' => 'Section',
'joinTable' =>
'INT_CONF_PAGE_SECTION',
'foreignKey' => 'SECTION_ID',
'associationForeignKey'=>
'PAGE_ID',
'conditions' => '',
'order' => '',
'limit' => '',
'uniq' => true,
'finderSql' => '',
'deleteQuery'=> '',
)
);
Any ideas why it isn't returning both page and section information in
the resultset?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
