Wes Gamble wrote: > This doesn't work. If I do: > > config.columns[:vendor_name].sort_by :sql => '(SELECT vendor_name FROM > vendors WHERE vendor_id = users.vendor_id)', then it generates this: > > SELECT * FROM `users` ORDER BY (SELECT vendor_name FROM vendors > WHERE vendor_id = users.vendor_id) ASC LIMIT 0, 10 > > which gives an error about subquery returning more than one row. >
I think your problem is pretty obvious? If you can't say what you want to sort on then how is the database supposed to sort the stuff for you? *What* are you trying to sort on? Ed --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" 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/activescaffold?hl=en -~----------~----~----~----~------~----~------~--~---
