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"]]