Getting value from query

Question

I'm having problems with getting a value from a single column call.

select sum(price) as testPrice from sales where quantity > 10

but when I inspect the resultset, I get the following,

[#"5"}>]

Any help is appreciated, thank you.

Doug Neiner · Accepted Answer · 2009-12-09 02:16:24Z

2

That is a very strange result. I am curious why you are not writing the query using ActiveRecord methods:

@testPrice = Sale.sum(:price, :conditions => "quantity > 10")

answered Dec 9, 2009 at 2:16

Doug Neiner

66.4k14 gold badges111 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Thank you very much!! Just been having problems with ActiveRecord, sigh ahah, but thank you again

yeah, it did. Is there any good API you know about, something like noobkit.com(that used to work)

Not that I have found. I just use api.rubyonrails.org but you have to really know what you are looking for.

Oh, and be sure to mark the question as "accepted" for future searchers. And welcome to Stack Overflow!