Changing Primary Key in Model is not being recognized

[Deftly-D]

I am trying to override the PrimaryKey used to join tables, but the
query that CakePHP is generating keeps using 'id' as the primary key.
This is in CakePHP version 1.3.7

Please suggest any changes that don't involve changing the database
structure.

The models that I am trying to join are as follows:


<?php
class VUser extends AppModel {
  var $name = 'VUser';

  var $useTable = 'v_users';
  var $primaryKey = 'userid';

  var $hasMany = array(
        'InterviewerID' => array(
                'className' => 'Sitelog',
                'foreignKey' => 'interviewerid'
        ),
        'ObserverID' => array(
                'className' => 'Sitelog',
                'foreignKey' => 'observerid'
        ),
        'CounterID' => array(
                'className' => 'Sitelog',
                'foreignKey' => 'counterid'
        )
  );

  var $validate = array(
        'orgid' => array('rule' => 'notEmpty'),
        'username' => array('rule' => 'notEmpty'),
        'phonenumber' => array('rule' => 'notEmpty'),
        'mailaddress' => array('rule' => 'notEmpty'),
        'loginid' => array('rule' => 'notEmpty'),
        'roleid' => array('rule' => 'notEmpty'),
        'terminatedate' => array('rule' => 'notEmpty'),
        'sid' => array('rule' => 'notEmpty'),
  );
}
?>



<?php
class Sitelog extends AppModel {

  var $name = 'Sitelog';

  var $useTable = 'site_log';
  var $primaryKey = 'sitelogid';

  var $belongsTo = array(
        'interviewer' => array(
                'className' => 'VUser',
                'foreignKey' => 'interviewerid'
        ),
        'observer' => array(
                'className' => 'VUser',
                'foreignKey' => 'observerid'
        ),
        'counter' => array(
                'className' => 'VUser',
                'foreignKey' => 'counterid'
        )
  );

  var $validate = array(
    'sitelogid' => array('rule' => 'notEmpty'),
    'psuid' => array('rule' => 'notEmpty'),
    'siteid' => array('rule' => 'notEmpty'),
    'statusid' => array('rule' => 'notEmpty'),
    'sitelogtype' => array('rule' => 'notEmpty'),
    'interviewerid' => array('rule' => 'notEmpty'),
    'observerid' => array('rule' => 'notEmpty'),
    'observerdate' => array('rule' => 'notEmpty'),
    'spanishavail' => array('rule' => 'notEmpty'),
    'counterid' => array('rule' => 'notEmpty')
  );
}
?>

-- 
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