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 "Theme" column to sort by theme, sort not reflect lexical order of themes but id order. I know it's normal because of the foreign key "theme_id" is the sorting key, but how can I make a lexical sort? On 12 juin, 13:15, avairet <[EMAIL PROTECTED]> wrote: > 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" which is the default > behavior. > > Here is the SQL request I would like to reproduce: > > "SELECT types.id, types.slug, types.name, famille_types.name FROM > types INNER JOIN famille_types_types ON famille_types_types.type_id = > types.id INNER JOIN famille_types ON > famille_types_types.famille_type_id = famille_types.id ORDER BY > famille_types.name" > > So how can I do that? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
