Monday, December 6, 2010

[Rails] SQL codes on Controller

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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate