SQL codes on Controller

rubyonrails-talk
1

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

2

Kishoj B. wrote in post #966523:

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 don't need to. Look up the docs for ActiveRecord::Calculations.

Best,