On Wednesday, 9 May 2012 19:13:58 UTC+2, [email protected] wrote: > > Hi, > > I am getting this Error: > > Error: SQLSTATE[42000]: Syntax error or access violation: 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 > 'erstelleAuswahl' at line 1 > > When I am trying to retrieve some data of my database. > Here is my function in KundenController.php > > public function erstelleAuswahl() { > $this->Kunde->recursive = -1; > $fields = array('Kunde.id', 'Kunde.anrede_id', > 'Kunde.vorname', 'Kunde.nachname', 'Kunde.name'); > $conditions = array('Kunde.gruppen_id' => $this->Auth- > >user('gruppen_id')); > $kundenliste = $this->Kunde->find('all', array('fields' => > $fields, 'conditions' => $conditions)); > foreach($kundenliste as $kunde) { > if($kunde['Kunde']['anrede_id'] == 'FA') { > $kunden[$kunde['Kunde']['id']] = $kunde['Kunde'] > ['name']; > } else { > $kunden[$kunde['Kunde']['id']] = $kunde['Kunde'] > ['nachname'].' '.$kunde['Kunde']['vorname']; > } > } > return $kunden; > //print_r($kunden); > } > > And if I am calling this function to get the array, I always get the > error. > I have debugged the SQL query, here it is: > > SELECT `Kunde`.`id`, `Kunde`.`anrede_id`, `Kunde`.`vorname`, > `Kunde`.`nachname`, `Kunde`.`name` FROM `mweb`.`kunden` AS `Kunde` > WHERE `Kunde`.`gruppen_id` = 1 > > If I run this query in phpMyAdmin I get my data. > So I have no Idea, what's the problem.
"... right syntax to use near 'erstelleAuswahl'" You are calling a method named "erstelleAuswahl" which doesn't exist. which probably means your model filename is misnamed. check the class of the object you're calling to confirm (it'll be AppModel) check that your model file follows conventions. AD -- 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
