Thanks.
BUt im still struggling, for example, theres a slight change:
select count(*) from outcomes o1 where o1.outcome_date = (select
max(o2.outcome_date) from outcomes o2 where o2.testrun_id =
o1.testrun_id and o2.testcase_id = o1.testcase_id and o1.testrun_id =
'31' and o1.result_id = '1');
I want to substitute the '31' with instance variable @testrun
so in your example, how do i escape the '' string to insert the instance
variable:
GUESS in CAPS:
...
....
o2.testcase_id = outcomes.testcase_id AND {OUTCOMES.TESTRUN_ID =>
@TESTRUN} and outcomes.result_id = "1")')
thanks though, i now understand alot more!
--
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
-~----------~----~----~----~------~----~------~--~---
