<% foreach $scannerID (keys(%scanners)) { $SQL = "SELECT Documents, Fronts, FrontsBlank, FrontsRescanned, FrontsDeleted, Rears, RearsBlank, RearsRescanned, RearsDeleted, ProcessStartDate FROM tblXVCSBatch WHERE ScanStationID = $scannerID"; # ProcessStartDate >= $DateQuote $dispStartDate $DateQuote AND # ProcessStartDate <= $DateQuote $dispEndDate $DateQuote"; $RS = $dbConn->Execute("$SQL"); while (!$RS->{EOF}) { $scanners{$scannerID}->{Batches}++; $scanners{$scannerID}->{Documents} += $RS->Fields(0)->{Value}; $scanners{$scannerID}->{Fronts} += $RS->Fields(1)->{Value}; $scanners{$scannerID}->{Fronts_Blank} += $RS->Fields(2)->{Value}; $scanners{$scannerID}->{Fronts_Rescanned} += $RS->Fields(3)->{Value}; $scanners{$scannerID}->{Fronts_Deleted} += $RS->Fields(4)->{Value}; $scanners{$scannerID}->{Rears} += $RS->Fields(5)->{Value}; $scanners{$scannerID}->{Rears_Blank} += $RS->Fields(6)->{Value}; $scanners{$scannerID}->{Rears_Rescanned} += $RS->Fields(7)->{Value}; $scanners{$scannerID}->{Rears_Deleted} += $RS->Fields(8)->{Value}; $RS->MoveNext(); } } %> #### $SQL = "SELECT Documents, Fronts, FrontsBlank, FrontsRescanned, FrontsDeleted, Rears, RearsBlank, RearsRescanned, RearsDeleted, ProcessStartDate FROM tblXVCSBatch WHERE ScanStationID = $scannerID AND ProcessStartDate >= $DateQuote $dispStartDate $DateQuote AND ProcessStartDate <= $DateQuote $dispEndDate $DateQuote";