Sub queries problem with Active Record

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

On Tue, Dec 13, 2011 at 8:31 PM, amvis [email protected] wrote:

problem when writing the corresponding rails queries…? I am using *

that some id error refers to the :id => part. remove that and it
should
work
**
Transaction.find(:conditions =>[“transaction_type = ? OR
transaction_type =
? OR transaction_type = ?”, ctype, ctype1,ctype2])

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.

Thanks for the reply…

sorry, that made a mistake when i post here. that query had’t an id. i
think the problem with rails version…? am using rails2.3.11.

This is mysql query select sum(points) from transactions where
transaction_type =“new_customer” or transaction_type= “review” or
transaction_type= “purchase”

*
*
and also have one sub query to convert into active record
*
*
select count()
from (
*

  • SELECT loyalty_id FROM transactions
    GROUP BY loyalty_id
    HAVING COUNT(*)>1

*) as t
*
*
*

On Tue, Dec 13, 2011 at 9:00 PM, amvis [email protected] wrote:

and also have one sub query to convert into active record
*
*
*

can you post the error and the code that causes it?

[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.