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
-~----------~----~----~----~------~----~------~--~---
