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 derfloh 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
Joined
May 26, 2006
Messages
7
Location
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