function &SelectLimit($sql, $nrows = -1, $offset = -1, $inputarr = false, $arg3 = false, $secs2cache = 0)
{
if (!preg_match('/ORDER[ \\t\\r\\n]+BY/i', $sql)) {
$sql .= ' ORDER BY 1';
}
return ADODBConnection::SelectLimit($sql, $nrows, $offset, $inputarr, $arg3, $secs2cache);
}
function &SelectLimit($sql, $nrows = -1, $offset = -1, $arg3 = false)
{
if ($offset <= 0) {
// could also use " OPTIMIZE FOR $nrows ROWS "
$sql .= " FETCH FIRST {$nrows} ROWS ONLY ";
return $this->Execute($sql, false, $arg3);
} else {
return ADODBConnection::SelectLimit($sql, $nrows, $offset, $arg3);
}
}
function ErrorNo()
{
if ($this->haserrorfunctions) {
$e = odbc_error($this->_connectionID);
// bug in 4.0.6, error number can be corrupted string (should be 6 digits)
// so we check and patch
if (strlen($e) <= 2) {
return 0;
}
return $e;
} else {
return ADODBConnection::ErrorNo();
}
}
function check_username_no_sid($username, $escape = 1)
{
if ($escape) {
$username = $this->SfStr->getSafeString($username, SAFE_STRING_DB);
} else {
$username = $this->SfStr->getSafeString($username, SAFE_STRING_ESC);
}
$query = "SELECT uid FROM {$this->CONF['db_tbl_prefix']}users WHERE username = {$username}";
$rs = $this->db->Execute($query);
if ($rs === FALSE) {
$this->error('Error checking for existing username: '******'uid'];
} else {
return false;
}
}
/**
* Delete Invoice
*
*/
function Delete()
{
$this->DB->Execute("DELETE FROM invoices WHERE id=?", array($this->ID));
}
