Very odd, it looks like your belongsTo variable is setup correctly.
It's clear that the SQL call that is generated is wrong though, It
includes Profile.level in the order by statement but doesn't join the
Profile table anywhere. I've created many belongsTo relationships just
how you have described with no problems. The only thing I can think of
is to make sure you also have a profile model setup in profile.php.
Other than that, I would suggest writing the join query manually:
SELECT `Person`.`id`, `Person`.`name`, `Person`.`profile_id`,
`PersonsProject`.`id`, `PersonsProject`.`person_id`,
`PersonsProject`.`project_id`, `PersonsProject`.`priority` FROM
`persons` AS `Person` JOIN `persons_projects` AS `PersonsProject` ON
(`PersonsProject`.`project_id` IN (15, 16, 17) AND
`PersonsProject`.`person_id` = `Person`.`id`)
JOIN profiles as Profile ON Profile.id = Person.profile_id ORDER BY
`PersonsProject`.`priority` ASC, `Profile`.`level` ASC
On Mar 24, 5:19 am, dandreta <[EMAIL PROTECTED]> wrote:
> any idea?
>
> On 19 mar, 13:39, dandreta <[EMAIL PROTECTED]> wrote:
>
> > If I add the relation in the model Person :
>
> > var $belongsTo = array('Profile' => array('className' => 'Profile',
> >
> > 'foreignKey' => 'profile_id',
> > 'order' =>
> > 'Profile.level ASC',
> > ),
> > );
>
> > And this function in persons controller.
> > function test(){
> > debug( $this->Person->findAll() );
>
> > }
>
> > I obtain an array where each person has one profile and persons are
> > correctly ordered by profile.level.
>
> > But the problem of the initial post continues.
> > This is the sql statement that generates the error(1054: Unknown
> > column 'Profile.level' in 'order clause'):
>
> > SELECT `Person`.`id`, `Person`.`name`, `Person`.`profile_id`,
> > `PersonsProject`.`id`, `PersonsProject`.`person_id`,
> > `PersonsProject`.`project_id`, `PersonsProject`.`priority` FROM
> > `persons` AS `Person` JOIN `persons_projects` AS `PersonsProject` ON
> > (`PersonsProject`.`project_id` IN (15, 16, 17) AND
> > `PersonsProject`.`person_id` = `Person`.`id`) ORDER BY
> > `PersonsProject`.`priority` ASC, `Profile`.`level` ASC
>
> > On 19 mar, 10:58, "[EMAIL PROTECTED]"
>
> > <[EMAIL PROTECTED]> wrote:
> > > Check your sql debug. Is the Profile table part of the query?
> > > If not you may not have set recursive high enough for it to be
> > > included.
>
> > > A test to see if the association is set right can be done easily by
> > > adding a test method to the persons controller.
> > > function test(){
> > > debug( $this->Person->findAll() );}
>
> > > you will get an ugly dump but is should contain an (empty) array for
> > > Profile for each Person.
>
> > > @Lisa:
> > > I think you can use the extra fields in the way attempted here. They
> > > are available in the sql-query but are not loaded as part of the data
> > > returned.
>
> > > On Mar 18, 5:25 pm, dandreta <[EMAIL PROTECTED]> wrote:
>
> > > > Thanks for yor response martin. I have tried to add the
> > > > relation(Person belongsTo Profile) in the model Person but the
> > > > error(Unknown colum) appears.
> > > > any help?
> > > > Regards
>
> > > > On 18 mar, 13:45, "[EMAIL PROTECTED]"
>
> > > > <[EMAIL PROTECTED]> wrote:
> > > > > You have: Profile hasOne Person but not any reference the other way.
> > > > > To get to the profile from Project to Person to Profile you also need
> > > > > the Person to belong to the Profile.
>
> > > > > Note on personal preference (i.e. not essential to getting things
> > > > > working):
> > > > > I prefer a person to have a profile and a profile to belong to a
> > > > > person unless you need the fk in that table for a reason. It really
> > > > > amounts to the same, it just sounds better when thinking about it.
>
> > > > > On Mar 18, 12:31 pm, dandreta <[EMAIL PROTECTED]> wrote:
>
> > > > > > Hi!
> > > > > > My doubt is the following one.
> > > > > > I have 3 tables with their respective models (Project, Person,
> > > > > > Profile).
> > > > > > A person has one profile and a profile corresponds to only one
> > > > > > person.
> > > > > > On the other hand, a person can realize several projects and a
> > > > > > project
> > > > > > can be realized by several persons. Summarizing, the tables and
> > > > > > relations of my models are these:
>
> > > > > > TABLE PROFILES
> > > > > > id, level
> > > > > > TABLE PERSONS
> > > > > > id, name, profile_id
> > > > > > TABLE PROJECTS
> > > > > > id, name
> > > > > > TABLE PERSONS_PROJECTS
> > > > > > id, person_id, project_id, priority (int extra field)
>
> > > > > > MODEL PROFILE
> > > > > > var $hasOne = array('Person' => array('className' => 'Person',
> > > > > > 'foreignKey' =>
> > > > > > 'profile_id')
> > > > > > );
>
> > > > > > MODEL PERSON
> > > > > > var $hasAndBelongsToMany = array(
> > > > > > 'Project' => array('className' => 'Project',
> > > > > > 'joinTable' => 'persons_projects',
> > > > > > 'foreignKey' => 'person_id',
> > > > > > 'associationForeignKey' => 'project_id')
> > > > > > );
>
> > > > > > MODEL PROJECT
> > > > > > var $hasAndBelongsToMany = array(
> > > > > > 'Person' => array('className' => 'Person',
> > > > > > 'joinTable' => 'persons_projects',
> > > > > > 'foreignKey' => 'project_id',
> > > > > > 'associationForeignKey' => 'person_id')
> > > > > > );
>
> > > > > > With all that, in projects_ controller I have a function that shows
> > > > > > a
> > > > > > project and its list of relationed persons. The problem is that I
> > > > > > want
> > > > > > that this list of persons is ordered (1º) by the field priority of
> > > > > > the
> > > > > > persons_projects table and (2º) by the field level of the profiles
> > > > > > table. I achieve the first thing, adding in the relation of the
> > > > > > Project model
>
> > > > > > $hasAndBelongsToMany= array('Person' => array('className' =>
> > > > > > 'Person',
> > > > > > ...............
> > > > > > 'order' => PersonsProject.priority ASC)
> > > > > > );
>
> > > > > > But, the problem appears ordering by the level field of the Profile
> > > > > > table, because if I change the previous code for:
> > > > > > 'Order' => ' PersonsProject.priority ASC, Profile.level ASC '
>
> > > > > > This error appears:
> > > > > > SQL error: 1054: Unknown column 'Profile.level' in ' order clause '
> > > > > > How can I solve it? I hope you can help me.
> > > > > > I use Cakephp 1.2.
> > > > > > Thanks and regards
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
