Hi,
I have the model configured with belongsto association.
In this the query outputted looks like
SELECT `Firstpage`.`firstpagesid`, `Firstpage`.`imgnum`,
`Firstpage`.`pageloc`, `Firstpage`.`desc_id`,
`actressdesctbl`.`actressnum`, `actressdesctbl`.`actressfname`,
`actressdesctbl`.`description`, `actressdesctbl`.`imgloc` FROM
`firstpages` AS `Firstpage` INNER JOIN `actressdesctbls` AS
`actressdesctbl` ON (`Firstpage`.`desc_id` = `actressdesctbl`.`id`)
WHERE `firstpage`.`pageloc` = 1 ORDER BY `firstpage`.`imgnum` asc
The model association is listed below as well
class firstpage extends AppModel {
public $name = 'firstpage';
public $belongsTo = array(
'actressdesctbl' => array(
'className' => 'actressdesctbl',
'foreignKey' => 'desc_id',
'type' => 'INNER'
)
);
}
Here the inner join is between desc_id in the firstpages table and
the id in the actressdesctbl. I dont want the inner join to default
to id in the actressdesctbls. Instead i have another column in the
same table to which I need to join...Can I override the default...I
dont want to use any prepared statement.
Thanks for your help.
Thanks
padma Kumar
--
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
