I use the SQL code in the controller as follow:

sql = ActiveRecord::Base.connection();
@countlikes = sql.execute("SELECT COUNT(rateint) as result FROM
rates");

But it returns the resuls as #<PGresult:0xb6ea00e0> in the view i.e.
@countlikes =  #<PGresult:0xb6ea00e0>

I wanted the integer value. I am wondering how to use sql codes in the
controller

-- 
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 [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.

Reply via email to