Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Need help to correct a simple script

by space_monk (Chaplain)
on Jan 07, 2013 at 16:08 UTC ( #1012053=note: print w/ replies, xml ) Need Help??


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.

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


Comment on Re: Need help to correct a simple script
Download Code
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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1012053]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (18)
As of 2015-07-28 15:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (257 votes), past polls