function countAvailable() { $record = new CRecordSante400(); // Some DB2 drivers won't allow WHERE 1 syntax, WHERE 1 = 1 working better $query = "SELECT COUNT(*) AS TOTAL FROM {$this->base}.{$this->table}\r\n WHERE 1 = 1\r\n "; $query .= $this->getFilterClause(); $record->query($query); return $record->consume("TOTAL"); }