Re^2: Compound Sql Statement

Thanks Jason, when I run this code...

$sql = <<EO_SQL;
 insert into tableone values('1', '2', '3')
 insert into tabletwo values('4', '5', '6')
 insert into tablethree values('7', '8', '9')
EOF_SQL

my $loadHandle = $dbh->prepare($sql);
  
$loadHandle->execute or
  die "Could not execute SQL statement $sql ... maybe invalid?";
[download]

I get an error stating, "Can't find string terminator "EO_SQL" anywhere before EOF"

Comment on Re^2: Compound Sql Statement Download Code

Replies are listed 'Best First'.
Re^3: Compound Sql Statement by sgifford (Prior) on Feb 25, 2005 at 15:14 UTC
There's a typo. Change: `$sql = <<EO_SQL;` [download] to: `$sql = <<EOF_SQL;` [download]	[reply] [d/l] [select]