Thank you very much. I'm blushing, even though you can't tell in email. -Chris
On 3/20/06, Cain, Mark <[EMAIL PROTECTED]> wrote: > Did you intend to put a space between << and END_OF_SQL? > str << END_OF_SQL > (buncha sql) > END_OF_SQL > > it looks like there is not supposed to be one in the documentation. > str <<END_OF_SQL > (buncha sql) > END_OF_SQL > > > --Mark > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Chris McMahon > Sent: Monday, March 20, 2006 12:44 PM > To: [email protected] > Subject: [Wtr-general] OT: big 'ol variables? > > 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 > > _______________________________________________ > Wtr-general mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/wtr-general > _______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
