On Feb 22, 3:48 pm, DanC <d.m.coleg...@durham.ac.uk> wrote:

> i.e. in my categories controller
>
>     @category = Category.find(params[:id])
>     @services=Service.find(:all, :order => "XXXXXXX", :conditions =>
> ['category_id = ?', @category.id])
>
If you join the discounts table you can just order by
discounts.percentage

Fred

> where XXXX relates to one of the columns in the discount table. The
> column gives the % discount available stored as an integer field.
>
> Any ideas on best practice here,
>
> I thought I could write a method into the Service.rb model file but
> although I can call the value easily I can't order by the entry.
>
>   def reduction
>     return discount.percentage
>   end
>
> All help appreciated.
>
> Dan C
--~--~---------~--~----~------------~-------~--~----~
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 rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to