Re: Issues with join

 $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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php