$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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
