function getOneRecord()
{
$record = new lmbMssqlRecord();
$queryId = $this->connection->execute($this->getSQL());
$values = mssql_fetch_assoc($queryId);
$record->import($values);
mssql_free_result($queryId);
if (is_array($values)) {
return $record;
}
}
function at($pos)
{
$query = $this->query;
if (is_array($this->sort_params)) {
$query .= ' ORDER BY ';
foreach ($this->sort_params as $field => $order) {
$query .= $this->connection->quoteIdentifier($field) . " {$order},";
}
$query = rtrim($query, ',');
}
$queryId = $this->connection->execute($query);
if (mssql_num_rows($queryId) > $pos) {
mssql_data_seek($queryId, $pos);
$res = mssql_fetch_assoc($queryId);
mssql_free_result($queryId);
} else {
$res = false;
}
if ($res) {
$record = new lmbMssqlRecord();
$record->import($res);
return $record;
}
}