I am using DBI on NT4 , Informix 7.24 on a Sun box.
The dbi driver is ADO.
I seem to have a bug someplace when an aggregate function is used with fetchrow_array.
Consider...

$salessel = qq/SELECT sum(ship_units),sum(ship_cost) FROM material_hist
   WHERE location_id = $locid 
   AND month_begin > (CURRENT - INTERVAL(365) DAY(5) to DAY)
   AND material_id = /;

(later)
$sql2 = $salessel . $material_id;
$sth2 = $dbh->prepare( $sql2 );
$sth2->execute();
($sales_units,$sales_cost) = $sth2->fetchrow_array();
$sth2->finish();


The result is that the "sum(ship_cost)" is in returned in both $sales_units and 
$ship_cost.
The statements works fine in dbaccess. 

Is this a bug in the ado driver or fetchrow_array? Bad code?
Suggestions?


Reply via email to