Re: Need help to correct a simple script

[space_monk]

in reply to Need help to correct a simple script

The SQL needs to be declared in the loop, as you're changing the variable $count each time. Consider the more idiomatic

foreach my $count (1..$tables) {
   my $sql =<<EOF;
....
EOF

    die ("Failed to insert row: " . DBI->errstr) if (!($dbh->do ($sql)
+));

}

Unfortunately you can't prepare and execute this statement with bound variables, as the table name is formed from one of the variables.

[terrykhatri531]

Hi

Thank you for your quick responses, I adjusted my script accordingly and now it works like a charm.

Rgds

Terry