Documentation TYPO3 par Ameos |
Public Member Functions | |
ADODB_borland_ibase () | |
BeginTrans () | |
ServerInfo () | |
& | SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0) |
Public Attributes | |
$databaseType = "borland_ibase" |
Definition at line 20 of file adodb-borland_ibase.inc.php.
ADODB_borland_ibase::BeginTrans | ( | ) |
Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().
Reimplemented from ADODB_ibase.
Definition at line 29 of file adodb-borland_ibase.inc.php.
ADODB_borland_ibase::ServerInfo | ( | ) |
Get server version info...
Reimplemented from ADODB_ibase.
Definition at line 38 of file adodb-borland_ibase.inc.php.
& ADODB_borland_ibase::SelectLimit | ( | $ | sql, | |
$ | nrows = -1 , |
|||
$ | offset = -1 , |
|||
$ | inputarr = false , |
|||
$ | secs2cache = 0 | |||
) |
Will select, getting rows from $offset (1-based), for $nrows. This simulates the MySQL "select * from table limit $offset,$nrows" , and the PostgreSQL "select * from table limit $nrows offset $offset". Note that MySQL and PostgreSQL parameter ordering is the opposite of the other. eg. SelectLimit('select * from table',3); will return rows 1 to 3 (1-based) SelectLimit('select * from table',3,2); will return rows 3 to 5 (1-based)
Uses SELECT TOP for Microsoft databases (when $this->hasTop is set) BUG: Currently SelectLimit fails with $sql with LIMIT or TOP clause already set
sql | ||
[offset] | is the row to start calculations from (1-based) | |
[nrows] | is the number of rows to get | |
[inputarr] | array of bind variables | |
[secs2cache] | is a private parameter only used by jlim |
Reimplemented from ADOConnection.
Definition at line 58 of file adodb-borland_ibase.inc.php.
References ADOConnection::CacheExecute(), and ADOConnection::Execute().