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
