Re: SQL Error: 1054: Unknown column

>
> Warning (512): SQL Error: 1054: Unknown column 'Usergroup.id' in
> 'where clause' [CORE\cake\libs\model\datasources\dbo_source.php, line
> 684]
> Query: SELECT `Usergroup`.`jobTitle`, `Usergroup`.`groupId` FROM
> `usergroups` AS `Usergroup`   WHERE `Usergroup`.`id` =
> 'administrator'    LIMIT 1
>
>
> The usergroups table has 2 fields: jobTitle & groupId.
> Both are VARCHAR type. jobTitle is primary key. no id field and no
> association to any other table.
>

Ambiguous :

WHERE `Usergroup`.`id` =
> 'administrator'

--
Regards,,,
mastanto (thom_)
http://mynameisthom.tumblr.com
http://mynameisthom.blogspot.com
http://www.twitter.com/mastanto_

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