*select count(*)
from (
*
* SELECT loyalty_id FROM transactions
GROUP BY loyalty_id
HAVING COUNT(*)>1
*
*) as t
*
problem when writing the corresponding rails queries...? I am using *
Rails2.3.11*
Also this have error *select sum(points) from transactions where
transaction_type ="new_customer" or transaction_type= "review" or
transaction_type= "purchase" . *
*
*
*I tried like this Transaction.find(:id => :conditions =>["transaction_type
= ? OR transaction_type = ? OR transaction_type = ?", ctype,
ctype1,ctype2]).sum("points"). but it shows some ID error*
*
*
*Thnk you*
*vishnu*
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/pcWTdVnyRQ0J.
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.
