Stephane Legault wrote:
> I do a lot of select in many statement and fetch the result on a array as
> needed. But now one of my staement is a "select count() from ...". How can
> I get the value of this statement?
I do not know what db you are using, etc, but here we are using oracle on a
*nix box. and it is just the same as any other db call
my $sth = $dbh->prepare("SELECT count(*) from dmg.papf_view")
or die "Cant prepare SQL statement: $DBI::errstr\n";
my @row;
while(@row = $sth->fetchrow_array()){
print "Row: @row\n";
}
chris
--
-------------------------------
Just Your Friendly Neighborhood
_SPIDEY_
