Working with a Legacy DB Question.

Hello All, My question is this. I'm trying to connect to a MySQL DB for read only in ROR

Class Report < ActiveRecord::Base     set_table_name "stories"     set_primary_key "record_id" end

script/console

story = Report.find(56734) #Retrieve just a specific record_id Works but I'm not able to iterate over this.

story.each { |fields| puts fields } NoMethodError: undefined method `each' for #<Editorial:0x4979ce0>   from /Library/Ruby/Gems/1.8/gems/activerecord-2.1.0/lib/active_record/ attribute_methods.rb:256:in `method_missing'   from (irb):226

So assuming there is another method that I can use to gather all or selected fields?

If I reference each filed by name it works story.record_id story.file_name

I'm sure I'm missing something very basic here. Thanks Sc

So assuming there is another method that I can use to gather all or selected fields?

If you want to iterate over all attributes, look at story.attributes.

Fred

Hello All, My question is this. I'm trying to connect to a MySQL DB for read only in ROR

Class Report < ActiveRecord::Base    set_table_name "stories"    set_primary_key "record_id" end

script/console

story = Report.find(56734) #Retrieve just a specific record_id Works but I'm not able to iterate over this.

story.each { |fields| puts fields } NoMethodError: undefined method `each' for #<Editorial:0x4979ce0>   from /Library/Ruby/Gems/1.8/gems/activerecord-2.1.0/lib/active_record/ attribute_methods.rb:256:in `method_missing'   from (irb):226   from :0

Report.find(56734) will return a single Report object Report.find([56734]) will return an array containing a single Report object.

Is that the iteration that you want?

So assuming there is another method that I can use to gather all or selected fields?

If I reference each filed by name it works story.record_id story.file_name

I'm sure I'm missing something very basic here. Thanks Sc

Otherwise, if you want the fields or attributes of a single Report (one row from stories and its columns), then Fred has already given you the hint.

-Rob

Rob Biedenharn http://agileconsultingllc.com Rob@AgileConsultingLLC.com

Hello All,

Thanks so much this has put me on the correct track. I was not sure how to get things into an array which this solves. I suppose I could also do a Stories.find(:all) and which returns and array.

Thanks everyone ..

sc