Pagination sorting by lexical order with HABTM?

2008-06-12 Thread avairet
TABLES : A) types: id, name, slug B) famille_types: id, name, type_famille C) famille_types_types (this is the join table) : type_id, famille_type_id MODEL ASSOCIATION : Type HABTM FamilleType In a index view, I would like paginate Type order by famille_types.name not famille_types.id

Re: Pagination sorting by lexical order with HABTM?

2008-06-12 Thread avairet
Another same kind of problem: Item hasOne Theme Foreign key = theme_id In Theme controller, I've setted $displayFields = 'name'; In my index view, the default paginate HTML table is good: Items are sorted by id and in the Theme column, names are displayed instead of ids. But when I click on

Re: Pagination sorting by lexical order with HABTM?

2008-06-12 Thread avairet
Sorry, in the previous post Item belongsTo Theme ! On 12 juin, 15:25, avairet [EMAIL PROTECTED] wrote: Another same kind of problem: Item hasOne Theme Foreign key = theme_id In Theme controller, I've setted $displayFields = 'name'; In my index view, the default paginate HTML table is