SQL codes on Controller

Rails
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,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

Sent from my iPhone