$totcnt=$this->Query2xmlRaw_Limit($this->sqltext, $offset, $numrows, 0);
break;
+ case "PostgreSQL":
+ $this->sqltext=$this->oParse->UnparseSelect()." LIMIT ".($numrows + 1) . " OFFSET ".$offset;
+ $totcnt=$this->Query2xmlRaw_Limit($this->sqltext, $offset, $numrows, 0);
+ break;
+
default:
$this->sqltext=$this->oParse->UnparseSelect();
$totcnt=$this->Query2xmlRaw($this->sqltext, $offset, $numrows);
$rsMain=$this->objDB->RunQuery($rawsqltext);
}
if (!$rsMain) {
- echo "\n<debug>Query2xmlRaw: rsMain is null - ".htmlspecialchars(odbc_error())."</debug>";
+ echo "\n<debug>Query2xmlRaw: rsMain is null - ".htmlspecialchars($this->objDB->ErrorMsg())."</debug>";
return;
}