FAQ
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

Search Discussions

  • Tilen Majerle at Jun 22, 2012 at 11:12 am
    $var = $this->Login->find('list',
    array('fields'=>array('Category', 'Category'),
    'conditions'=>array('Login.username'=>$dbuser['Login']['
    username'])));


    or disable primary key :D
    --
    Lep pozdrav, Tilen Majerle
    http://majerle.eu



    2012/6/22 sneha kulkarni <sneha.kulkarni122@gmail.com>
    $var = $this->Login->find('list',
    array('fields'=>array('Category'),

    'conditions'=>array('Login.username'=>$dbuser['Login']['username'])));
    --
    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
  • Madhuri yewale at Jun 27, 2012 at 11:36 am
    hiiiiii
    i have tried this code..actually the value which came in $var i.e category
    i want to compaire by if else condition to display particular page bt its
    not working..if i assing any category to $var its working...what should i
    do to compaire $var by if else condition..plz help me if possible

    On Fri, Jun 22, 2012 at 4:41 PM, Tilen Majerle wrote:

    $var = $this->Login->find('list',
    array('fields'=>array('Category', 'Category'),

    'conditions'=>array('Login.username'=>$dbuser['Login']['
    username'])));


    or disable primary key :D
    --
    Lep pozdrav, Tilen Majerle
    http://majerle.eu



    2012/6/22 sneha kulkarni <sneha.kulkarni122@gmail.com>
    $var = $this->Login->find('list',
    array('fields'=>array('Category'),

    'conditions'=>array('Login.username'=>$dbuser['Login']['username'])));
    --
    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
    --
    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcake-php @
categoriesphp
postedJun 22, '12 at 11:09a
activeJun 27, '12 at 11:36a
posts3
users3
websitecakephp.org
irc#cakephp

People

Translate

site design / logo © 2022 Grokbase