protected function executeSQLQueryLimit($connection, $command, $max, $skip)
{
if ($max > -1 || $skip > -1) {
$maxStr = $max > 0 ? ' LIMIT ' . $max : '';
$skipStr = $skip > 0 ? ' OFFSET ' . $skip : '';
$command->setText($command->getText() . $maxStr . $skipStr);
}
$connection->setActive(true);
return $command->query();
/*//var_dump($command);
try
{
$recordSet = $connection->selectLimit($sql['sql'],$max,$skip,$sql['parameters']);
if(!$recordSet)
{
throw new TSqlMapExecutionException(
'sqlmap_execution_error_query_for_list',
$connection->ErrorMsg());
}
return $recordSet;
}
catch (Exception $e)
{
throw new TSqlMapQueryExecutionException($this->getStatement(), $e);
}*/
}