Hi... Pardon the interruption, but I'm scratching my head over this one.
the "<<" syntax works fine for assigning a ton of XML to a variable "str" i.e. str = <<END_OF_XML <requestroot xmlns="http://foo";> <lastname xmlns="" >#{lstnm} < /lastname> <firstname xmlns="">#{fstnm}</firstname> </requestroot> END_OF_XML but if I try to assign a large SQL statement to a variable using the same technique, Ruby is trying to parse the parens and things as if the SQL were code: foo_test.rb:47: syntax error foo_test.rb:49: warning: don't put space before argument parentheses foo_test.rb:50: warning: parenthesize argument(s) for future version foo_test.rb:51: syntax error from FOOLIB.TABLE1 first_value ^ foo_test.rb:51: warning: parenthesize argument(s) for future version foo_test.rb:52: warning: parenthesize argument(s) for future version foo_test.rb:52: warning: parenthesize argument(s) for future version foo_test.rb:55: syntax error and FOOLIB.TABLE2.CRAZY_DATE > '9999-12-30-00.00.00.000000' ^ foo_test.rb:56: syntax error anyone have any suggestions for getting Ruby to Do The Right Thing when str << END_OF_SQL (buncha sql) END_OF_SQL ? Thanks and apologies... -Chris _______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
