KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Here is the code I'm using: # Run the query against the database defined in .yml file. # This is a Mysql::result object - http://www.tmtm.org/en/mysql/ruby/ @results = ActiveRecord::Base.connection.execute(@sql_query) In my View, here's what I do to see the values: <pre><%= debug @results %></pre> Outputs: #<Mysql2::Result:0x007f31849a1fc0> <% @results.each do |val| %> <%= val %> <% end %> Outputs: ["asdfasdf", 23, "qwefqwef"] ["sdfgdsf", 23, "asdfasdfasdf"] So imagine I query something like select * from Person , and that returns a result set such as: ID Name Age 1 Sergio 22 2 Lazlow 28 3 Zeus 47 How can I iterate through each value and output it? The documentation here is not useful because I have tried methods that supposedly exist, but the interpreter gives me an error saying that those methods don't exist. Am I using the wrong documentation? http://www.tmtm.org/en/mysql/ruby/ Thanks!
Tags (comma-separated)
Save Edits
Cancel