Skip to content
Tags

,

Running sql query in rails

March 17, 2011

Have a table that you want to run a query on that you do not map to a model?

Use this:

ActiveRecord::Base.connection.execute("Select * from widget ").entries

.entries returns an array of arrays. The outer array hold all records that match the query and the inner array holds the values of the columns for each record

Advertisements

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: