Problem:
The table AUTHORS has the fields (id, given_name, last_name, created, modified)
but no title field.
I wish to fill a select box with the id and FULL NAME that is created by
merging last_name and first_name. in SQL you'd do soemthing like:
SELECT id, CONCAT( last_name, ', ', first_name) AS title FROM authors
how can I use this form of "query" in CakePHP to generate the list using:
$this->set('authors', $this->Book->Author->generateList());
Thanks\
Adrian
---
Adrian Gould
Lecturer in IT / Network Engineering / Multimedia
Business Finance & Computing [Midland Campus]
Swan TAFE
PO BOX 1336, Midland WA 6936
Phone: (08) 9267 7777
eMail: [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
