I have written a function that joins together two fields, the query
that gets outputted for some reason has the ' instead of the `
symbols.
The following code:
$conditions = array('Formula.formulasId' => $id);
$fields = array(
'materials.description', 'formula.formulasId,
formula.materialsId,
formula.weight');
$instructions = $this->Formula->find('all',
array('conditions' => $conditions, 'fields' => $fields,
'alias' => 'formulas', 'joins' => array (
array(
'table' => 'materials',
'alias' => 'materials',
'conditions' => array('formula.materialsId' =>
'materials.file'),
'type' => 'left',
'foreignKey' => 'materials.id'
),
)));
outputs this as a result:
SELECT `materials`.`description`, formulas.formulasId,
formulas.materialsId, formulas.weight FROM `formulas` left JOIN
`materials` ON (`formulas`.`materialsId` = 'materials.file') WHERE
`formulas`.`formulasId` = 2
which nulls out the materials.description field. What I need is
CakePHP to output this:
SELECT `materials`.`description`, formulas.formulasId,
formulas.materialsId, formulas.weight FROM `formulas` AS `formulas`
left JOIN `materials` AS `materials` ON (`formulas`.`materialsId` =
materials.file) WHERE `formulas`.`formulasId` = 2;
Any help is super appreciated.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
