You are getting that error because it seems like your model is not found. Its using the AppModel in its place. Try debugging it.
debug($this->Workpiece); On May 14, 7:13 pm, dreamingmind <[email protected]> wrote: > erikober, > > I wonder if there is a syntax error higher up in the code. Getting > your function name returned as bad SQL is weird... but not unusual. > I've definitely seen it more than once in my pages. > > Anyhoo... this is such a simple query, GO NATIVE! In you're Model, > try: > > $this->find('all', array( > 'conditions' => array('WorkPiece.work_id' => 3), > 'order' => 'adorder' > ); > > Regards, > Don > > On May 14, 7:09 am, erikober <[email protected]> wrote: > > > > > > > > > Bogdan, thanks for the reply. > > > I agree... > > Probably should rethink all of it to avoid any custom queries. > > Still curious why it isn't working. > > > Here is more info: > > > $sql = "returnAdvertising" > > $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 'returnAdvertising' at line 1" > > $out = null > > > [CORE/cake/libs/model/datasources/dbo_source.php, line 681] > > > thanks. -- 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
