On Mon, Feb 14, 2011 at 12:58 PM, Jeremy Burns | Class Outfit < [email protected]> wrote:
> That all looks a little unusual. Can you explain in non-code terms what you > are trying to do? > > Jeremy Burns > Class Outfit > > [email protected] > http://www.classoutfit.com > > On 14 Feb 2011, at 20:55, cake-learner wrote: > > > Very often i got this error and i had to do custom query why it's not > > putting '*'? > > > > $this -> loadModel( 'Company.Role' ); > > $this -> Role -> useDbConfig = $this -> db_name; > > $arrRoles = $this -> Role -> find( "all" ); > > > > Warning (512): SQL Error: 1064: You have an error in your SQL syntax; > > check the manual that corresponds to your MySQL server version for the > > right syntax to use near 'FROM `roles` AS `Role` WHERE 1 = 1' at > > line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 535] > > > > Code | Context > > > > $sql = "SELECT FROM `roles` AS `Role` WHERE 1 = 1 " > > $error = "1064: You have an error in your SQL syntax; check > the manual > > that corresponds to your MySQL server version for the right syntax to > > use near 'FROM `roles` AS `Role` WHERE 1 = 1' at line 1" > > > > -- > > 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 > > [email protected] 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 > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > I am just trying to search on Model from different Controller. -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
