Re: Model Associations Question
In you code you have 'className' => 'Bookings'. Shouldn't that be
'className' = 'Booking' ?
You should also be able to shorten it to - var $belongsTo =
array('Booking') as you are using booking_id as your foreign key.
MArk
On Wednesday, June 27, 2012 2:34:25 AM UTC-4, Sanfly wrote:
>
> Sorry, I'll repost this - my database is Bookingdate not Bookingnight
>
> Hi
>
> Im having some trouble with a model association - yes, I have tried the
> manual!
>
> For each Booking I have, I can have many Bookingnights
>
> *Booking*
> Booking.id
>
>
> *Bookingdate*
> Bookingdate.id
> Bookingdate.booking_id
>
> In my Booking model, I am able to get all the associated Bookingdates
> without issue.
>
> var $hasMany = array(
> 'Bookingdate' => array(
> 'className' => 'Bookingdates',
> 'foreignKey'=> 'booking_id',
>
> )
>
> );
>
> My problem is when I try and go back the other way. I have my
> Bookingdate.id, and want to get the associated booking.
>
> I would think that it should be belongsTo in my Bookingdate model?
>
> var $belongsTo = array(
> 'Booking' => array(
> 'className' => 'Bookings',
> 'foreignKey' => 'booking_id'
> )
>
> );
>
> ==> Doesnt Work
>
> Is there something obvious that I'm missing?
>
> On Wednesday, 27 June 2012 18:26:42 UTC+12, Sanfly wrote:
>>
>> Hi
>>
>> Im having some trouble with a model association - yes, I have tried the
>> manual!
>>
>> For each Booking I have, I can have many Bookingnights
>>
>> *Booking*
>> Booking.id
>>
>>
>> *Bookingnight*
>> Bookingnight.id
>> Bookingnight.booking_id
>>
>> In my Booking model, I am able to get all the associated Bookingnights
>> without issue.
>>
>> var $hasMany = array(
>> 'Bookingdate' => array(
>> 'className' => 'Bookingdates',
>> 'foreignKey'=> 'booking_id',
>>
>> )
>>
>> );
>>
>> My problem is when I try and go back the other way. I have my
>> Bookingnight.id, and want to get the associated booking.
>>
>> I would think that it should be belongsTo?
>>
>> var $belongsTo = array(
>> 'Booking' => array(
>> 'className' => 'Bookings',
>> 'foreignKey' => 'booking_id'
>> )
>>
>> );
>>
>> ==> Doesnt Work
>>
>> Is there something obvious that I'm missing?
>>
>> Thanks!
>>
>>
>>
>>
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Model Associations Question
This seems more like an HABTM association. A Booking can have/belong to many BookingDate and vice versa. I wonder, though, if it might be better to drop the BookingDate model and instead use date ranges. Something like date_from & date_to, or arrival & departure, in the bookings table. On Wed, Jun 27, 2012 at 2:34 AM, Sanfly wrote: > Sorry, I'll repost this - my database is Bookingdate not Bookingnight > > > Hi > > Im having some trouble with a model association - yes, I have tried the > manual! > > For each Booking I have, I can have many Bookingnights > > Booking > Booking.id > > > Bookingdate > Bookingdate.id > Bookingdate.booking_id > > In my Booking model, I am able to get all the associated Bookingdates > without issue. > > > var $hasMany = array( > 'Bookingdate' => array( > 'className' => 'Bookingdates', > 'foreignKey' => 'booking_id', > > ) > > ); > > My problem is when I try and go back the other way. I have my > Bookingdate.id, and want to get the associated booking. > > I would think that it should be belongsTo in my Bookingdate model? > > > var $belongsTo = array( > 'Booking' => array( > 'className' => 'Bookings', > 'foreignKey' => 'booking_id' > ) > > ); > > ==> Doesnt Work > > Is there something obvious that I'm missing? > > On Wednesday, 27 June 2012 18:26:42 UTC+12, Sanfly wrote: >> >> Hi >> >> Im having some trouble with a model association - yes, I have tried the >> manual! >> >> For each Booking I have, I can have many Bookingnights >> >> Booking >> Booking.id >> >> >> Bookingnight >> Bookingnight.id >> Bookingnight.booking_id >> >> In my Booking model, I am able to get all the associated Bookingnights >> without issue. >> >> var $hasMany = array( >> 'Bookingdate' => array( >> 'className' => 'Bookingdates', >> 'foreignKey' => 'booking_id', >> >> ) >> >> ); >> >> My problem is when I try and go back the other way. I have my >> Bookingnight.id, and want to get the associated booking. >> >> I would think that it should be belongsTo? >> >> var $belongsTo = array( >> 'Booking' => array( >> 'className' => 'Bookings', >> 'foreignKey' => 'booking_id' >> ) >> >> ); >> >> ==> Doesnt Work >> >> Is there something obvious that I'm missing? >> >> Thanks! >> >> >> > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Model Associations Question
Sorry, I'll repost this - my database is Bookingdate not Bookingnight Hi Im having some trouble with a model association - yes, I have tried the manual! For each Booking I have, I can have many Bookingnights *Booking* Booking.id *Bookingdate* Bookingdate.id Bookingdate.booking_id In my Booking model, I am able to get all the associated Bookingdates without issue. var $hasMany = array( 'Bookingdate' => array( 'className' => 'Bookingdates', 'foreignKey'=> 'booking_id', ) ); My problem is when I try and go back the other way. I have my Bookingdate.id, and want to get the associated booking. I would think that it should be belongsTo in my Bookingdate model? var $belongsTo = array( 'Booking' => array( 'className' => 'Bookings', 'foreignKey' => 'booking_id' ) ); ==> Doesnt Work Is there something obvious that I'm missing? On Wednesday, 27 June 2012 18:26:42 UTC+12, Sanfly wrote: > > Hi > > Im having some trouble with a model association - yes, I have tried the > manual! > > For each Booking I have, I can have many Bookingnights > > *Booking* > Booking.id > > > *Bookingnight* > Bookingnight.id > Bookingnight.booking_id > > In my Booking model, I am able to get all the associated Bookingnights > without issue. > > var $hasMany = array( > 'Bookingdate' => array( > 'className' => 'Bookingdates', > 'foreignKey'=> 'booking_id', > > ) > > ); > > My problem is when I try and go back the other way. I have my > Bookingnight.id, and want to get the associated booking. > > I would think that it should be belongsTo? > > var $belongsTo = array( > 'Booking' => array( > 'className' => 'Bookings', > 'foreignKey' => 'booking_id' > ) > > ); > > ==> Doesnt Work > > Is there something obvious that I'm missing? > > Thanks! > > > > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
