Hello,
At the moment i'm using three models, two of them have the same
database and the other one uses a different one.
the center model name is coursedate, a coursedate is linked to a course
(this works) but it's also linked to a user(teacher) but this doesn't
work(from another DB).
here are the model klasses;
<?php
class TblCourseDate extends AppModel {
var $primaryKey = 'cda_id';
var $name = 'TblCourseDate';
var $hasOne = array(
'TblCourse' => array(
'className' => 'TblCourse',
'foreignKey' => false,
'conditions' => 'TblCourse.crs_id =
TblCourseDate.cda_crs_id'),
'TblUser' => array(
'className' => 'TblUser',
'foreignKey' => false,
'conditions' => 'TblUser.usr_id =
TblCourseDate.cda_usr_id')
);
}
?>
<?php
class TblCourse extends AppModel {
var $primaryKey = 'crs_id';
var $name = 'TblCourse';
var $hasOne = array(
'TblGroup' => array(
'className' => 'TblGroup',
'foreignKey' => false,
'conditions' => 'TblCourse.crs_grp_id = TblGroup.grp_id')
);
?>
<?php
class TblUser extends AppModel {
var $useDbConfig = 'tmp';
var $useTable = 'tbl_users';
var $name = 'TblUser';
var $primaryKey = 'usr_id';
?>
controller class
<?php
uses('L10n');
class TblCourseDatesController extends AppController {
var $name = 'TblCourseDates';
function index() {
$this->set('TblCourseDates', $this->TblCourseDate->find('all'));
$this->set('pagetitle', 'Datums');
}
?>
it generates these queries but the last one doesn't work/is wrong
SELECT TblCourseDate.cda_id, TblCourseDate.cda_date,
TblCourseDate.cda_max_students, TblCourseDate.cda_crs_id,
TblCourseDate.cda_usr_id, TblCourseDate.cda_ext_docent,
TblCourse.crs_id, TblCourse.crs_name, TblCourse.crs_desc,
TblCourse.crs_type, TblCourse.crs_grp_id FROM tbl_course_dates
TblCourseDate LEFT JOIN tbl_courses TblCourse ON (TblCourse.crs_id =
TblCourseDate.cda_crs_id) WHERE TblCourseDate.cda_id = 9
(works)
SELECT TblUser.usr_full_name, TblUser.usr_first_name,
TblUser.usr_user_yn, TblUser.usr_active_start, TblUser.usr_last_name,
TblUser.usr_email, TblUser.usr_active_end, TblUser.usr_id,
TblUser.usr_login FROM tbl_users TblUser WHERE TblUser.usr_id =
TblCourseDate.cda_usr_id
(fails)
anyone knows what i'm doing wrong?
thanks in advance
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
