Formatting results from SQL in Ruby On Rails

Question

I have a custom SQL query that I run with this line:

@avg_score = "#{ActiveRecord::Base.connection.execute(@avg_score_SQL)}"

when that is run, @avg_score has a value of:

[{"score"=>8, 0=>8}]

the results are correct, but it prints it like that :-/ I just want it to print out the "8"

How do I get it to just print the value of score?

try select_one instead of execute

Fivell
– Fivell

2012-03-25 16:14:51 +00:00
Commented Mar 25, 2012 at 16:14 — Fivell
– Fivell, Commented Mar 25, 2012 at 16:14

Justin Workman · Accepted Answer · 2012-03-25 16:16:35Z

2

[{"score"=>8, 0=>8}] is just an array with one element, and that element is a hash. So you can access the score like this:

@avg_score[0]['score']

answered Mar 25, 2012 at 16:16

Justin Workman

6986 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fivell · Accepted Answer · 2012-03-25 17:27:45Z

0

if you use execute method, you have to free the Result object after you're done using it. Also your statement can be used without quotes. if you always have 1 result row, you should better use selecy_one

@avg_score = ActiveRecord::Base.connection.select_one(@avg_score_SQL)['score']

edited Mar 25, 2012 at 17:27

answered Mar 25, 2012 at 17:20

Fivell

11.9k4 gold badges63 silver badges101 bronze badges

Collectives™ on Stack Overflow

Formatting results from SQL in Ruby On Rails

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related