I tried changing the name of FK in both the database and model and it
still does not work. I have used BelongsTo before with plural FK and
it worked. I wonder if it has something to do with my code and naming
convention

Names are,
Database = irrigation_events
Model = IrrigationEvent (irrigationEvent.php)
Controller = IrrigationEventsController
(irrigation_events_controller.php)

These are my set functions in the controller
$this->set('irrigationEvents', $this->IrrigationEvent->findAll());
$this->set('fields',$this->IrrigationEvent->Field->find('list'));

I think I might not be using the right plural/camel case conventions
any ideas?

Travis

On Jul 19, 2:25 pm, Carlos Lavin <[email protected]> wrote:
> Cake expects it to be called field_id... although im not sure that is whats
> creating the problem.. give it a shot and let us know
>
> 2009/7/19 Travis <[email protected]>
>
>
>
>
>
> > "fields_id" is what the FK is called in the table,
>
> > I have a table called fields, when I created the foreign key in
> > irrigation_events I called it fields_id.
>
> > Travis
>
> > On Jul 16, 1:30 pm, Piotr Kilczuk <[email protected]> wrote:
> > > Hello,
>
> > > > I have successfully set up other belongsto relationships in this
> > > > program but one does not work
>
> > > > the model code is:
>
> > > > class IrrigationEvent extends AppModel
> > > > {
> > > >    var $name = 'IrrigationEvent';
> > > >    var $useTable = 'irrigation_events';
> > > >    var $belongsTo = array(
> > > >            'Field' => array(
> > > >                'className' => 'Field',
> > > >                'foreignKey'=> 'fields_id'
> > > >        ));
> > > > }
> > > > ?>
>
> > > FK should be field_id?
>
> > > Regards,
> > > Piotr
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to