select_rows(sql, name = nil) public

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

Show source
Register or log in to add new notes.
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"]]