Alright... I just set up a hasOne and a belongsTo for my users and
articles tables, and now I am getting this error:

SQL Error in model Article: 1052: Column 'active' in where clause is
ambiguous

Here are my findAll calls:
                $this->set('articles', $this->Article->findAll('active = 1', 
null,
'created desc', 30, 1, 3));
                $this->set('inactive_articles', $this->Article->findAll('active 
!=
1', null, 'created desc', 30, 1, 3));


Article model:
    var $belongsTo = array('User' =>
                           array('className'  => 'User',
                                 'conditions' => '',
                                 'order'      => '',
                                 'foreignKey' => ''
                           )
                     );

User model:
    var $hasMany = array('Article' =>
                         array('className'   => 'Article',
                               'conditions'  => '',
                               'order'       => '',
                               'limit'       => '',
                               'foreignKey'  => '',
                               'dependent'   => false,
                               'exclusive'   => false,
                               'finderSql'   => ''
                         )
                  );


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

Reply via email to