$this->paginate['Member']['conditions'], here are conditions list to search... -- Lep pozdrav, Tilen Majerle http://majerle.eu
2011/3/8 heohni <[email protected]> > Hi, > > $options['Member.agent_id'] = $this->Session->read('AgentId'); > $options['or'] = array( > 'mem_nummer LIKE' => '%'.$q.'%', > 'mitg_vorname LIKE' => '%'.$q.'%', > 'mitg_nachname LIKE' => '%'.$q.'%', > 'mitg_strasse LIKE' => '%'.$q.'%', > 'mitg_plz LIKE' => '%'.$q.'%', > 'mitg_ort LIKE' => '%'.$q.'%', > 'mitg_email LIKE' => '%'.$q.'%' > ); > > $results = $this->paginate('Member', $options); > > How can I add a fields limitation to the options array? > > Example: > $options['fields'] = array('Member.id'); > performs an error: SQL Error: 1054: Unknown column 'fields' in 'where > clause' > as it add the fields to the WHERE sections: > WHERE fields = ('Member.id') > > What do I do wrong here? > Please advice! > > 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 > -- 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
