Thanks a lot, Coder. I am working with 1.1 too. I will try.
Anch
On Aug 21, 9:07 am, Angry Coder <[EMAIL PROTECTED]> wrote:
> I forgot to mention I am working with Cake 1.1
>
> On Aug 21, 10:05 am, Angry Coder <[EMAIL PROTECTED]> wrote:
>
> > Hi Anch,
>
> > Here are some of the things within the Model class which you can
> > override that may help:
>
> > var $useTable = null;
> > var $displayField = null;
> > var $primaryKey = null;
>
> > 1. $primaryKey variable will allow you to override the column used as
> > the primary key.
>
> > 2. Yes you need specify the details in your associations
>
> > For instance in your Article Model:
>
> > var $hasAndBelongsToMany = array(
> > 'Users' =>
> > array('className' => 'Users',
> > 'joinTable' =>
> > 'user_articles',
> > 'foreignKey' =>
> > 'article_id',
> > 'associationForeignKey' =>
> > 'user_id',
> > 'conditions' => '',
> > 'fields' => '',
> > 'order' => '',
> > 'limit' => '',
> > 'offset' => '',
> > 'unique' => '',
> > 'finderQuery' => '',
> > 'deleteQuery' => '',
> > 'insertQuery' => ''
> > ),
>
> > );
>
> > I left in the other fields you can specify for completeness sake.
>
> > Also if the other field is a auto increment field you can ignore it it
> > should just by populated by the database.
>
> > Cheers,
>
> > Coder
>
> > On Aug 21, 9:30 am, anch <[EMAIL PROTECTED]> wrote:
>
> > > Hi, I am building a CakePHP-based application using all the database
> > > tables built by another application. However, the database tables
> > > related to models are defined differently from CakePHP's convention.
>
> > > We have the following tables: articles, users, ratings for the models:
> > > Article, User, and Rating; the associations among them include the
> > > following, "Article hasOne Rating" and "User hasAndBelongsToMany
> > > Article"
>
> > > I have the following questions:
>
> > > 1. In the articles table, article_id was used as the column name for
> > > the article id (the primary key). When I try to access ratings records
> > > associated with Article, it generated the following error:
>
> > > SQL Error: 1054: Unknown column 'Article.id' in 'on clause' in /var/
> > > www/html/cake/cake/libs/model/datasources/dbo_source.php on line 463
>
> > > I guess CakePHP was expecting the column name to be 'id' in the
> > > articles table. If so, can I work around this problem without changing
> > > the column name?
>
> > > 2. The join table was named as user_articles. According to CakePHP
> > > convention, it should be articles_users. Is there anyway I can
> > > override the CakePHP convention to use user_articles instead? Also
> > > there was an extra field for record id (thus it has three columns: id,
> > > article_id, user_id), can we live with this?
>
> > > Could anybody help me to resolve the above issues to override the
> > > CakePHP convention? Thanks a lot.
>
> > > Best regards,
> > > Anch
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
