Class ADODB_sybase

Description

Connection object. For connecting to databases, and executing queries.

Located in /3rd/adodb/drivers/adodb-sybase.inc.php (line 21)

ADOConnection
   |
   --ADODB_sybase
Direct descendents
Class Description
 class ADODB_sybase_ase Connection object. For connecting to databases, and executing queries.
Variable Summary
Method Summary
 ADODB_sybase ADODB_sybase ()
 void BeginTrans ()
 void CommitTrans ([ $ok = true])
 void ErrorMsg ()
 void MetaPrimaryKeys ( $table)
 void RollbackTrans ()
 void RowLock ( $tables,  $where, [ $flds = 'top 1 null as ignore'])
 void SelectDB ( $dbName)
 void &SelectLimit ( $sql, [ $nrows = -1], [ $offset = -1], [ $inputarr = false], [ $secs2cache = 0])
 void SQLDate ( $fmt, [ $col = false])
 void UnixDate ( $v)
 void UnixTimeStamp ( $v)
 void _affectedrows ()
 void _close ()
 void _connect ( $argHostname,  $argUsername,  $argPassword,  $argDatabasename)
 void _insertid ()
 void _pconnect ( $argHostname,  $argUsername,  $argPassword,  $argDatabasename)
 void _query ( $sql,  $inputarr)
Variables
mixed $arrayClass = 'ADORecordSet_array_sybase' (line 38)

Redefinition of:
ADOConnection::$arrayClass
mixed $concat_operator = '+' (line 37)

Redefinition of:
ADOConnection::$concat_operator
mixed $databaseType = "sybase" (line 22)

Redefinition of:
ADOConnection::$databaseType

Redefined in descendants as:
mixed $dataProvider = 'sybase' (line 23)

Redefinition of:
ADOConnection::$dataProvider
mixed $fmtDate = "'Y-m-d'" (line 25)

Redefinition of:
ADOConnection::$fmtDate
mixed $fmtTimeStamp = "'Y-m-d H:i:s'" (line 26)

Redefinition of:
ADOConnection::$fmtTimeStamp
mixed $hasAffectedRows = true (line 28)

Redefinition of:
ADOConnection::$hasAffectedRows
mixed $hasInsertID = true (line 27)

Redefinition of:
ADOConnection::$hasInsertID
mixed $leftOuter = '*=' (line 40)

Redefinition of:
ADOConnection::$leftOuter
mixed $metaColumnsSQL = "SELECT c.column_name, c.column_type, c.width FROM syscolumn c, systable t WHERE t.table_name='%s' AND c.table_id=t.table_id AND t.table_type='BASE'" (line 31)

Redefined in descendants as:
mixed $metaTablesSQL = "select name from sysobjects where type='U' or type='V'" (line 29)

Redefinition of:
ADOConnection::$metaTablesSQL

Redefined in descendants as:
mixed $replaceQuote = "''" (line 24)

Redefinition of:
ADOConnection::$replaceQuote
mixed $rightOuter = '=*' (line 41)

Redefinition of:
ADOConnection::$rightOuter
mixed $sysDate = 'GetDate()' (line 39)

Redefinition of:
ADOConnection::$sysDate

Inherited Variables

Inherited from ADOConnection

ADOConnection::$ansiOuter
ADOConnection::$autoCommit
ADOConnection::$autoRollback
ADOConnection::$blobEncodeType
ADOConnection::$cacheSecs
ADOConnection::$charSet
ADOConnection::$database
ADOConnection::$debug
ADOConnection::$emptyDate
ADOConnection::$emptyTimeStamp
ADOConnection::$false
ADOConnection::$fetchMode
ADOConnection::$fnCacheExecute
ADOConnection::$fnExecute
ADOConnection::$genID
ADOConnection::$hasGenID
ADOConnection::$hasLimit
ADOConnection::$hasMoveFirst
ADOConnection::$hasTop
ADOConnection::$hasTransactions
ADOConnection::$host
ADOConnection::$isoDates
ADOConnection::$lastInsID
ADOConnection::$length
ADOConnection::$maxblobsize
ADOConnection::$metaDatabasesSQL
ADOConnection::$nameQuote
ADOConnection::$noNullStrings
ADOConnection::$numCacheHits
ADOConnection::$numCacheMisses
ADOConnection::$pageExecuteCountRows
ADOConnection::$password
ADOConnection::$poorAffectedRows
ADOConnection::$raiseErrorFn
ADOConnection::$random
ADOConnection::$readOnly
ADOConnection::$rsPrefix
ADOConnection::$substr
ADOConnection::$sysTimeStamp
ADOConnection::$transCnt
ADOConnection::$transOff
ADOConnection::$true
ADOConnection::$uniqueOrderBy
ADOConnection::$uniqueSort
ADOConnection::$upperCase
ADOConnection::$user
ADOConnection::$_affected
ADOConnection::$_bindInputArray
ADOConnection::$_connectionID
ADOConnection::$_errorCode
ADOConnection::$_errorMsg
ADOConnection::$_evalAll
ADOConnection::$_isPersistentConnection
ADOConnection::$_logsql
ADOConnection::$_oldRaiseFn
ADOConnection::$_queryID
ADOConnection::$_transOK
Methods
Constructor ADODB_sybase (line 43)
ADODB_sybase ADODB_sybase ()
BeginTrans (line 59)
void BeginTrans ()

Redefinition of:
ADOConnection::BeginTrans()
Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().
CommitTrans (line 69)
void CommitTrans ([ $ok = true])
  • $ok

Redefinition of:
ADOConnection::CommitTrans()
If database does not support transactions, always return true as data always commited
ErrorMsg (line 110)
void ErrorMsg ()

Redefinition of:
ADOConnection::ErrorMsg()

Redefined in descendants as:
MetaPrimaryKeys (line 253)
void MetaPrimaryKeys ( $table)
  • $table

Redefinition of:
ADOConnection::MetaPrimaryKeys()
RollbackTrans (line 80)
void RollbackTrans ()

Redefinition of:
ADOConnection::RollbackTrans()
If database does not support transactions, rollbacks always fail, so return false
RowLock (line 89)
void RowLock ( $tables,  $where, [ $flds = 'top 1 null as ignore'])
  • $tables
  • $where
  • $flds

Redefinition of:
ADOConnection::RowLock()
Lock a row, will escalate and lock the table if row locking not supported will normally free the lock at the end of the transaction
SelectDB (line 97)
void SelectDB ( $dbName)
  • $dbName

Redefinition of:
ADOConnection::SelectDB()
Choose a database to connect to. Many databases do not support this.
SelectLimit (line 153)
void &SelectLimit ( $sql, [ $nrows = -1], [ $offset = -1], [ $inputarr = false], [ $secs2cache = 0])
  • $sql
  • $nrows
  • $offset
  • $inputarr
  • $secs2cache

Redefinition of:
ADOConnection::SelectLimit()
Will select, getting rows from $offset (1-based), for $nrows.
SQLDate (line 191)
void SQLDate ( $fmt, [ $col = false])
  • $fmt
  • $col

Redefinition of:
ADOConnection::SQLDate()
UnixDate (line 175)
void UnixDate ( $v)
  • $v

Redefinition of:
ADOConnection::UnixDate()
Also in ADORecordSet.
UnixTimeStamp (line 180)
void UnixTimeStamp ( $v)
  • $v

Redefinition of:
ADOConnection::UnixTimeStamp()
Also in ADORecordSet.
_affectedrows (line 53)
void _affectedrows ()
_close (line 170)
void _close ()
_connect (line 121)
void _connect ( $argHostname,  $argUsername,  $argPassword,  $argDatabasename)
  • $argHostname
  • $argUsername
  • $argPassword
  • $argDatabasename
_insertid (line 48)
void _insertid ()
_pconnect (line 131)
void _pconnect ( $argHostname,  $argUsername,  $argPassword,  $argDatabasename)
  • $argHostname
  • $argUsername
  • $argPassword
  • $argDatabasename
_query (line 142)
void _query ( $sql,  $inputarr)
  • $sql
  • $inputarr

Inherited Methods

Inherited From ADOConnection

 ADOConnection::ADOConnection()
 ADOConnection::addq()
 ADOConnection::Affected_Rows()
 ADOConnection::AutoExecute()
 ADOConnection::BeginTrans()
 ADOConnection::BlobDecode()
 ADOConnection::BlobEncode()
 ADOConnection::CacheExecute()
 ADOConnection::CacheFlush()
 ADOConnection::CacheGetAll()
 ADOConnection::CacheGetArray()
 ADOConnection::CacheGetAssoc()
 ADOConnection::CacheGetCol()
 ADOConnection::CacheGetOne()
 ADOConnection::CacheGetRow()
 ADOConnection::CachePageExecute()
 ADOConnection::CacheSelectLimit()
 ADOConnection::Close()
 ADOConnection::CommitLock()
 ADOConnection::CommitTrans()
 ADOConnection::CompleteTrans()
 ADOConnection::Concat()
 ADOConnection::Connect()
 ADOConnection::CreateSequence()
 ADOConnection::DBDate()
 ADOConnection::DBTimeStamp()
 ADOConnection::Disconnect()
 ADOConnection::DropSequence()
 ADOConnection::ErrorMsg()
 ADOConnection::ErrorNative()
 ADOConnection::ErrorNo()
 ADOConnection::escape()
 ADOConnection::Execute()
 ADOConnection::FailTrans()
 ADOConnection::GenID()
 ADOConnection::GetAll()
 ADOConnection::GetArray()
 ADOConnection::GetAssoc()
 ADOConnection::GetCharSet()
 ADOConnection::GetCol()
 ADOConnection::GetInsertSQL()
 ADOConnection::GetOne()
 ADOConnection::GetRow()
 ADOConnection::GetUpdateSQL()
 ADOConnection::HasFailedTrans()
 ADOConnection::IfNull()
 ADOConnection::InParameter()
 ADOConnection::Insert_ID()
 ADOConnection::IsConnected()
 ADOConnection::LimitQuery()
 ADOConnection::LogSQL()
 ADOConnection::MetaColumnNames()
 ADOConnection::MetaColumns()
 ADOConnection::MetaDatabases()
 ADOConnection::MetaError()
 ADOConnection::MetaErrorMsg()
 ADOConnection::MetaForeignKeys()
 ADOConnection::MetaIndexes()
 ADOConnection::MetaPrimaryKeys()
 ADOConnection::MetaTables()
 ADOConnection::MetaType()
 ADOConnection::NConnect()
 ADOConnection::nextId()
 ADOConnection::OffsetDate()
 ADOConnection::outp()
 ADOConnection::OutParameter()
 ADOConnection::PageExecute()
 ADOConnection::Param()
 ADOConnection::Parameter()
 ADOConnection::PConnect()
 ADOConnection::PO_Insert_ID()
 ADOConnection::Prepare()
 ADOConnection::PrepareSP()
 ADOConnection::q()
 ADOConnection::QMagic()
 ADOConnection::qstr()
 ADOConnection::Query()
 ADOConnection::Quote()
 ADOConnection::Replace()
 ADOConnection::RollbackLock()
 ADOConnection::RollbackTrans()
 ADOConnection::RowLock()
 ADOConnection::SelectDB()
 ADOConnection::SelectLimit()
 ADOConnection::SerializableRS()
 ADOConnection::ServerInfo()
 ADOConnection::SetCharSet()
 ADOConnection::SetDateLocale()
 ADOConnection::SetFetchMode()
 ADOConnection::SQLDate()
 ADOConnection::StartTrans()
 ADOConnection::Time()
 ADOConnection::UnixDate()
 ADOConnection::UnixTimeStamp()
 ADOConnection::UpdateBlob()
 ADOConnection::UpdateBlobFile()
 ADOConnection::UpdateClob()
 ADOConnection::UserDate()
 ADOConnection::UserTimeStamp()
 ADOConnection::Version()
 ADOConnection::_Execute()
 ADOConnection::_findschema()
 ADOConnection::_findvers()
 ADOConnection::_gencachename()
 ADOConnection::_nconnect()
 ADOConnection::_rs2rs()

Documentation generated on Wed, 23 Jan 2008 19:34:24 -0500 by phpDocumentor 1.4.0