Using data from a query fired in rails


I have a query that returns a single number that I want to use further
in my program.

Could you please let me know how I could access the data inside the
object returned by the query.

I invoke it as:

numscens = Progressions.find_by_sql("select numscenarios from
progressions where id = #{params[:progressionid]}

The data in numscens that I get is >> numscenarios.to_xml:

<?xml version="1.0" encoding="UTF-8"?> 2

I want to access the number in the numscenarios tag.

Apologies for the novice question.

Many Thanks,

What is numscenarios? if it is a column name then you should be able to
access it like any active record find. NOTE: you can’t update unless you
have the id field.