Hi again folks, still not having any luck with this. Here's what I
currently have:
$tags = $this->Output->Tag->find("list", array(
"fields"=>array(
"{n}.Tag.id",
"{n}.Tag.name",
"{n}.TagType.name"),
"order"=>array(
"TagType.name",
"Tag.name ASC"
),
"recursive"=>0
));
I've tested this in the current Beta and the nightly build and get the
following error:
Query: SELECT `{n}`.`Tag`, `{n}`.`TagType`, `Tag`.`id` FROM `tags` AS
`Tag` LEFT JOIN `tag_types` AS `TagType` ON (`Tag`.`tag_type_id` =
`TagType`.`id`) WHERE 1 = 1 ORDER BY `TagType`.`name` ASC,
`Tag`.`name` ASC
Warning (512): SQL Error: 1109: Unknown table '{n}' in field list [CORE
\cake\libs\model\datasources\dbo_source.php, line 440]
It looks like {n} isn't being parsed correctly?
Here's the model (in case I've messed up in there):
var $hasAndBelongsToMany = array(
'OutputType' => array('className' => 'OutputType',
'joinTable' =>
'outputs_output_types',
'foreignKey' => 'output_id',
'associationForeignKey' =>
'output_type_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
),
'Tag' => array('className' => 'Tag',
'joinTable' => 'outputs_tags',
'foreignKey' => 'output_id',
'associationForeignKey' =>
'tag_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
),
'Theme' => array('className' => 'Theme',
'joinTable' => 'outputs_themes',
'foreignKey' => 'output_id',
'associationForeignKey' =>
'theme_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
)
);
If you remove the {n} from the find(), the tags are outputted, but no
option groups are displayed (the tags ARE grouped by category however,
just displayed as one long list)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
