[CDBI] order_by with joined tables?

Perrin Harkins perrin at elem.com
Thu Nov 2 19:59:36 GMT 2006


On Thu, 2006-11-02 at 11:14 -0800, Alan wrote:
> select name,fullname 
> from people join company on company.id = people.company_id
> where blah 
> order by company.name
> 
> However I don't know how to get this into the nice CDBI framework :(

You need set_sql.
http://wiki.class-dbi.com/wiki/Beginners_guide#set_sql

- Perrin




More information about the ClassDBI mailing list