Fred no worries i DONE IT!!
controller.rb: @test1 = Result.find_by_id(:joins => Outcome.find_by_testcase_id(@testcase, :order => 'outcome_date desc')) view.rhtml: <%= h @test1.resulttype %> thanks for your help, i can now see find_by_sql is more of a liability than using the "filters" of the find command. great! thanks for your help! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---

