Re: belongsTo and parent data.

2008-09-25 Thread James Pearson
I found the problem, I had saved the Event model as Events.php instead of Event.php D'oh! JP On Sep 24, 7:15 pm, teknoid <[EMAIL PROTECTED]> wrote: > Are your foreign keys named correctly? > What does your SQL debug tell you about the query? > > On Sep 24, 1:06 pm, James  Pearson <[EMAIL PROTE

Re: belongsTo and parent data.

2008-09-25 Thread James Pearson
The event table has eventtype_id as the FK. The SQL for $this->Event->find('first'); does a simple select from events with no joins or errors, which is the confusing part. It is like Cake isn't trying to get the parent information. On Sep 24, 7:15 pm, teknoid <[EMAIL PROTECTED]> wrote: > Are

Re: belongsTo and parent data.

2008-09-24 Thread teknoid
Are your foreign keys named correctly? What does your SQL debug tell you about the query? On Sep 24, 1:06 pm, James Pearson <[EMAIL PROTECTED]> wrote: > Good Evening, > > I'm new to cake, and have reached a dead end with  a hasMany, belongTo > problem, and wondered if you guys could help. > > Th

belongsTo and parent data.

2008-09-24 Thread James Pearson
Good Evening, I'm new to cake, and have reached a dead end with a hasMany, belongTo problem, and wondered if you guys could help. This problem has 2 models, Event and EventType. An Event belongs to an Event Type, for example a soccer match event would be of the sports event type. My models ar