hi,
Iam very new to perl.
Here iam trying to connect to Database and trying to fetch the node names of customer by using sql. i am expecting that my query needs to be prepared and executed and returns the reuslts.
but its not happening.
i am giving the code below
my $sql = qq{ SELECT node_name FROM customer_node_history };
my $sth = $zdb->prepare( $sql ) or die "Error preparing sql: $zdb->errstr";
$sth->execute() or die "Error executing sql: $zdb->errstr";
print($sth);
Iam very new to perl.
Here iam trying to connect to Database and trying to fetch the node names of customer by using sql. i am expecting that my query needs to be prepared and executed and returns the reuslts.
but its not happening.
i am giving the code below
my $sql = qq{ SELECT node_name FROM customer_node_history };
my $sth = $zdb->prepare( $sql ) or die "Error preparing sql: $zdb->errstr";
$sth->execute() or die "Error executing sql: $zdb->errstr";
print($sth);
Last edited by Raj on Wed Dec 10, 2008 6:36 am; edited 2 times in total (Reason for editing : Do not post copyright material.)