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

Located in /3rd/adodb/drivers/adodb-mssql.inc.php (line 73)

ADOConnection
   |
   --ADODB_mssql

mixed $ansiOuter = true (line 100)

---

Redefinition of:

ADOConnection::$ansiOuter

mixed $arrayClass = 'ADORecordSet_array_mssql' (line 96)

---

Redefinition of:

ADOConnection::$arrayClass

mixed $databaseType = "mssql" (line 74)

---

Redefinition of:

ADOConnection::$databaseType

---

Redefined in descendants as:

• ADODB_mssqlpo::$databaseType

mixed $dataProvider = "mssql" (line 75)

---

Redefinition of:

ADOConnection::$dataProvider

mixed $fmtDate = "'Y-m-d'" (line 77)

---

Redefinition of:

ADOConnection::$fmtDate

mixed $fmtTimeStamp = "'Y-m-d h:i:sA'" (line 78)

---

Redefinition of:

ADOConnection::$fmtTimeStamp

mixed $hasAffectedRows = true (line 82)

---

Redefinition of:

ADOConnection::$hasAffectedRows

mixed $hasGenID = true (line 91)

---

Redefinition of:

ADOConnection::$hasGenID

mixed $hasInsertID = true (line 79)

---

Redefinition of:

ADOConnection::$hasInsertID

mixed $hasTop = 'top' (line 90)

---

Redefinition of:

ADOConnection::$hasTop

mixed $identitySQL = 'select @@IDENTITY' (line 102)

mixed $leftOuter = '*=' (line 98)

---

Redefinition of:

ADOConnection::$leftOuter

mixed $length = 'len' (line 81)

---

Redefinition of:

ADOConnection::$length

mixed $maxParameterLen = 4000 (line 95)

mixed $metaColumnsSQL =
"select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s'" (line 85)

mixed $metaDatabasesSQL = "select name from sysdatabases where name <> 'master'" (line 83)

---

Redefinition of:

ADOConnection::$metaDatabasesSQL

mixed $metaTablesSQL = "select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties'))" (line 84)

---

Redefinition of:

ADOConnection::$metaTablesSQL

mixed $poorAffectedRows = true (line 101)

---

Redefinition of:

ADOConnection::$poorAffectedRows

mixed $replaceQuote = "''" (line 76)

---

Redefinition of:

ADOConnection::$replaceQuote

mixed $rightOuter = '=*' (line 99)

---

Redefinition of:

ADOConnection::$rightOuter

mixed $substr = "substring" (line 80)

---

Redefinition of:

ADOConnection::$substr

mixed $sysDate = 'convert(datetime,convert(char,GetDate(),102),102)' (line 92)

---

Redefinition of:

ADOConnection::$sysDate

mixed $sysTimeStamp = 'GetDate()' (line 93)

---

Redefinition of:

ADOConnection::$sysTimeStamp

mixed $uniqueOrderBy = true (line 103)

---

Redefinition of:

ADOConnection::$uniqueOrderBy

mixed $uniqueSort = true (line 97)

---

Redefinition of:

ADOConnection::$uniqueSort

mixed $_bindInputArray = true (line 104)

---

Redefinition of:

ADOConnection::$_bindInputArray

mixed $_dropSeqSQL = "drop table %s" (line 159)

mixed $_has_mssql_init (line 94)

Inherited Variables

Inherited from ADOConnection

ADOConnection::$autoCommit
ADOConnection::$autoRollback
ADOConnection::$blobEncodeType
ADOConnection::$cacheSecs
ADOConnection::$charSet
ADOConnection::$concat_operator
ADOConnection::$database
ADOConnection::$debug
ADOConnection::$emptyDate
ADOConnection::$emptyTimeStamp
ADOConnection::$false
ADOConnection::$fetchMode
ADOConnection::$fnCacheExecute
ADOConnection::$fnExecute
ADOConnection::$genID
ADOConnection::$hasLimit
ADOConnection::$hasMoveFirst
ADOConnection::$hasTransactions
ADOConnection::$host
ADOConnection::$isoDates
ADOConnection::$lastInsID
ADOConnection::$maxblobsize
ADOConnection::$nameQuote
ADOConnection::$noNullStrings
ADOConnection::$numCacheHits
ADOConnection::$numCacheMisses
ADOConnection::$pageExecuteCountRows
ADOConnection::$password
ADOConnection::$raiseErrorFn
ADOConnection::$random
ADOConnection::$readOnly
ADOConnection::$rsPrefix
ADOConnection::$transCnt
ADOConnection::$transOff
ADOConnection::$true
ADOConnection::$upperCase
ADOConnection::$user
ADOConnection::$_affected
ADOConnection::$_connectionID
ADOConnection::$_errorCode
ADOConnection::$_errorMsg
ADOConnection::$_evalAll
ADOConnection::$_isPersistentConnection
ADOConnection::$_logsql
ADOConnection::$_oldRaiseFn
ADOConnection::$_queryID
ADOConnection::$_transOK

Constructor ADODB_mssql (line 106)

ADODB_mssql ADODB_mssql ()

BeginTrans (line 272)

void BeginTrans ()

---

Redefinition of:

ADOConnection::BeginTrans()

Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().

CommitTrans (line 280)

void CommitTrans ([ $ok = true])

• $ok

---

Redefinition of:

ADOConnection::CommitTrans()

If database does not support transactions, always return true as data always commited

Concat (line 542)

void Concat ()

---

Redefinition of:

ADOConnection::Concat()

Different SQL databases used different methods to combine strings together.

CreateSequence (line 161)

void CreateSequence ([ $seq = 'adodbseq'], [ $start = 1])

• $seq
• $start

---

Redefinition of:

ADOConnection::CreateSequence()

ErrorMsg (line 467)

void ErrorMsg ()

---

Redefinition of:

ADOConnection::ErrorMsg()

ErrorNo (line 475)

void ErrorNo ()

---

Redefinition of:

ADOConnection::ErrorNo()

GenID (line 174)

void GenID ([ $seq = 'adodbseq'], [ $start = 1])

• $seq
• $start

---

Redefinition of:

ADOConnection::GenID()

Generates a sequence id and stores it in $this->genID; GenID is only available if $this->hasGenID = true;

IfNull (line 139)

void IfNull ( $field,  $ifNull)

• $field
• $ifNull

---

Redefinition of:

ADOConnection::IfNull()

MetaDatabases (line 395)

void MetaDatabases ()

---

Redefinition of:

ADOConnection::MetaDatabases()

return the databases that the driver can connect to.

MetaForeignKeys (line 355)

void MetaForeignKeys ( $table, [ $owner = false], [ $upper = false])

• $table
• $owner
• $upper

---

Redefinition of:

ADOConnection::MetaForeignKeys()

MetaIndexes (line 315)

void &MetaIndexes ( $table, [ $primary = false])

• $table
• $primary

---

Redefinition of:

ADOConnection::MetaIndexes()

List indexes on a table as an array.

MetaPrimaryKeys (line 418)

void &MetaPrimaryKeys ( $table)

• $table

---

Redefinition of:

ADOConnection::MetaPrimaryKeys()

MetaTables (line 443)

void &MetaTables ([ $ttype = false], [ $showSchema = false], [ $mask = false])

• $ttype
• $showSchema
• $mask

---

Redefinition of:

ADOConnection::MetaTables()

Parameter (line 580)

void Parameter ( &$stmt,  &$var,  $name, [ $isOutput = false], [ $maxLen = 4000], [ $type = false])

• &$stmt
• &$var
• $name
• $isOutput
• $maxLen
• $type

---

Redefinition of:

ADOConnection::Parameter()

Prepare (line 516)

void Prepare ( $sql)

• $sql

---

Redefinition of:

ADOConnection::Prepare()

Should prepare the sql statement and return the stmt resource.

PrepareSP (line 527)

void PrepareSP ( $sql)

• $sql

---

Redefinition of:

ADOConnection::PrepareSP()

Some databases, eg. mssql require a different function for preparing stored procedures. So we cannot use Prepare().

---

Redefined in descendants as:

• ADODB_mssqlpo::PrepareSP()

RollbackTrans (line 288)

void RollbackTrans ()

---

Redefinition of:

ADOConnection::RollbackTrans()

If database does not support transactions, rollbacks always fail, so return false

RowLock (line 308)

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 458)

void SelectDB ( $dbName)

• $dbName

---

Redefinition of:

ADOConnection::SelectDB()

Choose a database to connect to. Many databases do not support this.

SelectLimit (line 198)

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.

ServerInfo (line 111)

void ServerInfo ()

---

Redefinition of:

ADOConnection::ServerInfo()

SQLDate (line 212)

void SQLDate ( $fmt, [ $col = false])

• $fmt
• $col

---

Redefinition of:

ADOConnection::SQLDate()

UnixDate (line 708)

void UnixDate ( $v)

• $v

---

Redefinition of:

ADOConnection::UnixDate()

Also in ADORecordSet.

UnixTimeStamp (line 713)

void UnixTimeStamp ( $v)

• $v

---

Redefinition of:

ADOConnection::UnixTimeStamp()

Also in ADORecordSet.

UpdateBlob (line 628)

void UpdateBlob ( $table,  $column,  $val,  $where, [ $blobtype = 'BLOB'])

• $table
• $column
• $val
• $where
• $blobtype

---

Redefinition of:

ADOConnection::UpdateBlob()

Update a blob column, given a where clause. There are more sophisticated blob handling functions that we could have implemented, but all require a very complex API. Instead we have chosen something that is extremely simple to understand and use.

_affectedrows (line 154)

void _affectedrows ()

_close (line 699)

void _close ()

_connect (line 490)

void _connect ( $argHostname,  $argUsername,  $argPassword,  $argDatabasename)

• $argHostname
• $argUsername
• $argPassword
• $argDatabasename

_insertid (line 144)

void _insertid ()

_pconnect (line 501)

void _pconnect ( $argHostname,  $argUsername,  $argPassword,  $argDatabasename)

• $argHostname
• $argUsername
• $argPassword
• $argDatabasename

_query (line 640)

void _query ( $sql,  $inputarr)

• $sql
• $inputarr

---

Redefined in descendants as:

• ADODB_mssqlpo::_query()

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()