http://www.perlmonks.org?node_id=1012053


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)
+));

}

[download]

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

A Monk aims to give answers to those who have none, and to learn from those who know more.

Replies are listed 'Best First'.
Re^2: Need help to correct a simple script
by terrykhatri531 (Novice) on Jan 07, 2013 at 18:36 UTC
    Hi

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

    Rgds

    Terry
[reply]

In Section Seekers of Perl Wisdom