Try defining your model classes whitout the 'order_' prefix, and set
$useTable = 'order_whatever'; in the model.
2007/11/30, Luke <[EMAIL PROTECTED]>:
>
> umm I might have asked the question wrong. here is what I am trying to
> do:
>
> I have 3 tables: orders, order_items, and order_notes
>
> Orders is full of all of my store's orders. Order items are all the
> items the customer purchased, and order_notes contains all of the
> notes associated with an order. so the tables look like:
>
> orders:
>
> id
> date
> customer_name
> customer_phone
> customer_etc
> total
>
> order_items:
>
> id
> order_id
> name
> description
> price
> sku
>
> order_notes:
> order_id
> note
> date
>
> So it isn't a many-to-many association, it's just two one-to-many
> associates.
>
> On Nov 30, 9:17 am, Anupom <[EMAIL PROTECTED]> wrote:
> > Join tables should be named after the tables that will join, in
> > alphabetical order, with underscores in between. As an example, a join
> > table between posts and tags tables should be named posts_tags, not
> > tags_posts.
> >
> > The default value of the foreign keys used in the join table must be
> > underscored, singular name of the models in relation, suffixed with
> > '_id'.
> > Like, post_id, tag_id.
> >
> > If you want to override the defaults, you can explicitly define it in
> > the association attribute of the model -
> >
> > <?php
> > class Post extends AppModel
> > {
> > var $name = 'Post';
> >
> > var $hasAndBelongsToMany = array(
> > 'Tag' =>
> > array('className' => 'Tag',
> > 'joinTable' => 'tags_posts, //altered the
> > default - posts_tags
> > 'foreignKey' => 'article_id', //altered
> > the default -post_id
> > 'associationForeignKey' => 'category_id' //altered
> > the default - tag_id
> > )
> > );}
> >
> > ?>
> >
> > On Nov 30, 2007 11:12 PM, Jon Bennett <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> >
> >
> > > > Always best to stick to a A-Z (why can't I think of the correct term
> > > > for that!)
> >
> > > ALPHABETICAL!!!!
> >
> > > cheers,
> >
> > > jon
> >
> > > --
> >
> > > jon bennett
> > > w:http://www.jben.net/
> > > iChat (AIM): jbendotnet Skype: jon-bennett
> >
> > --
> > Thanks
> > Anupom
> > Trippert Inc. [http://www.trippert.com]
> > GopherNow. [http://www.gophernow.com/]
> > Homepage. [http://www.anupom.wordpress.com/]
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
