I am in a ruby on rails environment on a windows machine. I have an app that connects to an sql database.?

Question

I want to have a method in my controllers defined that returns the count of records in a users database. Is this the correct syntax? What am I doing wrong. I seem to get an error.

def users
@users = User.find(:all)
sql = ActiveRecord::Base.connection();
sql.execute "SET autocommit=0";
sql.begin_db_transaction
id, value =sql.execute("SELECT COUNT(*) as "Number of Users" FROM users;").fetch_row;
sql.commit_db_transaction
@count=value;
end

Answer 1

Doesn't this do the trick for you:

@count = User.count

??