Hi everyone, My question is: How do I override named_scope settings rather than merge with them?
Say I have a model Vehicles It has a named_scope called red_trucks that sets some filters and an order by id. Now lets say I want to find the unique values for an attribute. So I might go Vehicles.red_trucks.find(:all, "SELECT DISTINCT model_year") This breaks in postgres with the following error "for SELECT DISTINCT, ORDER BY expressions must appear in select list" ok, so lets add the model_year Vehicles.red_trucks.find(:all, "SELECT DISTINCT model_year", :order=>"model_year") This still gives me the same error because the 'order by id' is still there from the red_trucks name_scope. How do I override the order so it because "model_year" instead of "model_year,id"? Or is there a better way of doing this? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
