Book.find(:all,
:conditions=>["release_date >= ? and release_date < ? and
book_type='New'",@date[:from],@date[:to]],
:group=>"auther_id",
:order=>"count(*) desc",
:select=>"auther_id,sum(case when auther_type = 'New' "+
"then 1 else 0 end) as new,sum(case when auther_type != 'New' then
1 else 0 end) as review,count(*) as total")
in the above query how to write the "case" conditions in ruby query.
can anyone tell me which is the equivalent ruby syntax for this
sum(case when auther_type != 'New' then 1 else 0 end) as review
thanks in advance
Jk
--
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 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
-~----------~----~----~----~------~----~------~--~---
