Friday, June 22, 2012

Unknown column 'Login.id' in 'field list'

hi

when i execute this

$var = $this->Login->find('list',
         array('fields'=>array('Category'),
            'conditions'=>array('Login.username'=>$dbuser['Login']['username'])));


Warning (512): SQL Error: 1054: Unknown column 'Login.id' in 'field list' [CORE\cake\libs\model\datasources\dbo_source.php, line 684]

Query: SELECT `Login`.`id`, `Login`.`Category` FROM `logins` AS `Login` WHERE `Login`.`username` = 'seema'

 in my login table i dont have taken id column but in query it takes id..still i dont understand ..what changes i should make..to fetch category..plz help me

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: