Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

disappearing statement handles

Status
Not open for further replies.

kp2a

ISP
May 26, 2006
7
0
0
US
can anyone explain this weird behavior?
alive but dead
dies at last line

Code:
my $db = DBI->install_driver('mysql')
    or die;
my $ipplan = DBI->connect('DBI:mysql:host=[URL unfurl="true"]www;database=ipplan','xxxx','xxxxx')[/URL]
    or die;
my $C = $ipplan->prepare("SELECT count(*),sum(if(lastpol > ?,1,0)) as recent  FROM ipaddr WHERE baseindex = ?")
    or die;
my $L = $ipplan->prepare("SELECT max(lastpol)  FROM ipaddr WHERE baseindex = ?")
    or die
my $B = $ipplan->prepare("SELECT * FROM base WHERE subnetsize > 1 ORDER BY baseaddr")
    or die;
die unless $C && $L && $B ;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top