$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' = 'formula.materialsId =
materials.file',
'type' = 'left',
'foreignKey' = 'materials.id'
),
)));
Em sábado, 25 de fevereiro de 2012 18h58min32s UTC-2, bbowler86 escreveu:
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