Re: Re: [DB_DataObject] Struggling with n:m-relation

Hi Alan Am Do, 2004-06-03 um 16.38 schrieb Alan Knowles: > Marco Schuler wrote: [...] > > > > What I want is a query like: > > > > SELECT * from teacher, teacher_has_teachersubject, teachersubject > > WHERE teacher.teacher_id = teacher_has_teachersubject.teacher_id > > AND teacher_has_teachersubject.teachersubject_id = > > teachersubject.teachersubject_id > > AND teacher.teacher_surname = 'SomeTeachersSurname' > > > > $teacher = DB_DataObject::factory('teacher'); > $teacher->joinAdd( > DB_DataObject::factory('teacher_has_teachersubject'), > '' ); // <-- '' indicates join without 'JOIN'... > $teacher->joinAdd( > DB_DataObject::factory('teachersubject'), > '' ); // <-- '' indicates join without 'JOIN'... > > $teacher->teacher_surname = 'SomeTeachersSurname'; > $teacher->find(); > > use DB_DataObject::Debuglevel(1); to see what you are getting.. Output with DB_DataObject::Debuglevel(1); gives the following messages: teacher: ERROR: joinAdd: teachersubject has no link with teacher teacher: __find: teacher: QUERY: SELECT * FROM teacher , teacher_has_teachersubject WHERE teacher_has_teachersubject.teacher_id=teacher.teacher_id AND teacher.teacher_surname = 'SomeTeachersSurname' A $teacher->find() gives me the teachersubject_id but no data from table teachersubject is returned :-( Any idea? -- Regards Marco