RE: Re: Reading from a file and writing the content into a database

[chromatic]

my $sth = $dbh->prepare(<<SQL) or die "Can't prepare: ", $dbh->errstr;
insert into data
(data_1, data_2)
values (?, ?)
SQL

You can do that with a here doc? that's just amazing. How in the world did you figure that out?

[btrott]

It looks like it's in perlfaq4, under Why don't my <<HERE documents work?. There's an example like this:

# all in one
($VAR = <<HERE_TARGET) =~ s/^\s+//gm;
    your text
    goes here
HERE_TARGET

Pretty neat little trick. :)