ooooh, excellent. Thanks for that tip, I had a feeling that there
must be a way to tell cake about the funky primary keys
On May 29, 6:57 pm, Adam Royle <[EMAIL PROTECTED]> wrote:
> Have you told cake about your non-standard primary key? Add em like
> this in your models.
>
> class Booking extends AppModel {
>
> var $name = 'Booking';
> var $primaryKey = 'b_id';
>
> ... etc ...
>
> }
>
> Cheers,
> Adam
>
> On May 29, 3:51 pm, Sanfly <[EMAIL PROTECTED]> wrote:
>
> > Hi
>
> > Im trying to run two loops in one of my scripts to insert information
> > into my database and running into the same problem for both of them.
> > The info inserts into the database exactly as I would expect, but on
> > my view it throws me the errors below, and I cant figure out why
> > because I dont see why it should be trying to do that particular query
> > - I havent asked it to (so far as I know, but I'm a noob and I still
> > dont really get cake...)
>
> > My databases are a carry on from a previous system and not exactly
> > classically named: eg: my primary key for one is 'db_id' and the
> > other is 'b_id' rather than them both just being 'id'.
>
> > In this particular example i have three inserts/saves in my loop, and
> > the error is only thrown for the first two 'bookings'. If I change my
> > database naming, so 'b_id' is now just 'id', then I dont get any
> > errors, but only the last (third) booking is inserted into the
> > database.
>
> > Does anyone know how to solve this problem? Or at the very least hide
> > the errors in my view?
>
> > Im hoping cake will make my life easier in the long run, but so far
> > its taken me a week to do something that would have taken me less than
> > a day in native PHP!!!
>
> > The Errors eg:
>
> > Query: SELECT COUNT(id) AS count FROM `bookings` WHERE `id` = 42
> > Warning: SQL Error: 1054: Unknown column 'id' in 'field list' in G:
> > \WAMP\www\UASC Sourceforge\trunk\cake\libs\model\datasources
> > \dbo_source.php on line 440
>
> > Query: SELECT COUNT(id) AS count FROM `bookings` WHERE `id` = 43
> > Warning: SQL Error: 1054: Unknown column 'id' in 'field list' in G:
> > \WAMP\www\UASC Sourceforge\trunk\cake\libs\model\datasources
> > \dbo_source.php on line 440
>
> > The foreach loop:
>
> > foreach($this->data['Booking'] as $theBooking){
> > $theBooking['b_created_at'] = date("Y-m-d H:i:s");
> > $theBooking['b_booking_group_id'] = $booking_group_id;
> > $this->Booking->save($theBooking);
>
> > }
>
> > $this->data['Booking'] is an array that comes from my form on the
> > previous page, eg:
>
> > <input type="hidden" name="data[Booking][1][b_name]" value="<? echo
> > $members['Member']['first_name'] . " " . $members['Member']
> > ['last_name']; ?>" />
> > <input type="hidden"
> > name="data[Booking][1][b_contact_phone]"
> > value="<? echo $members['Member']['phone']; ?>" />
> > <input type="hidden"
> > name="data[Booking][1][b_member_no]"
> > value="<? echo $members['Member']['id']; ?>" />
> > <input type="hidden"
> > name="data[Booking][1][b_member_group]"
> > value="<? echo $members['Member']['member_group_id']; ?>" />
> > <input type="hidden"
> > name="data[Booking][1][b_is_contact_person]"
> > value="1" />
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
