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.