method

select_rows

v2.2.1 - Show latest stable - 1 note - Class: ActiveRecord::ConnectionAdapters::DatabaseStatements

1.0.0
1.1.6
1.2.6
2.0.3 (0)
2.1.0 (8)
2.2.1 (0)
2.3.8 (0)
3.0.0 (0)
3.0.9 (-38)
3.1.0 (0)
3.2.1 (0)
3.2.8 (0)
3.2.13 (0)
4.0.2 (0)
4.1.8 (0)
4.2.1 (0)
4.2.7 (0)
4.2.9 (0)
5.0.0.1 (0)
5.1.7 (0)
5.2.3 (0)
6.0.0 (0)
6.1.3.1 (0)
6.1.7.7 (0)
7.0.0 (0)
7.1.3.2 (0)
7.1.3.4 (0)
7.2.3 (0)
8.0.0 (0)
8.1.1 (0)
What's this?

select_rows(sql, name = nil) public

Returns an array of arrays containing the field values. Order is the same as that returned by columns.

# File activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb, line 33
      def select_rows(sql, name = nil)
        raise NotImplementedError, "select_rows is an abstract method"
      end

April 9, 2009

1 thank

Like select_values for multiple values

The names are somewhat confused:

Model.connection.select_values("SELECT id,name FROM users") => ["1","2","3"]
Model.connection.select_rows("SELECT id,name FROM users") => [["1","amy"],["2","bob"],["3","cam"]]

select_rows

Related methods

Like select_values for multiple values