Class: ADODB_mssql

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::$memCache

ADOConnection::$memCacheCompress

ADOConnection::$memCacheHost

ADOConnection::$memCachePort

ADOConnection::$nameQuote

ADOConnection::$noNullStrings

ADOConnection::$null2null

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::$_transmode

ADOConnection::$_transOK

Inherited From ADOConnection

ADOConnection::ADOConnection()

Constructor

ADOConnection::addq()

Quotes a string, without prefixing nor appending quotes.

ADOConnection::Affected_Rows()

ADOConnection::AutoExecute()

ADOConnection::BeginTrans()

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

ADOConnection::BindDate()

ADOConnection::BindTimeStamp()

ADOConnection::BlobDecode()

ADOConnection::BlobEncode()

ADOConnection::CacheExecute()

Execute SQL, caching recordsets.

ADOConnection::CacheFlush()

Flush cached recordsets that match a particular $sql statement.

ADOConnection::CacheGetAll()

ADOConnection::CacheGetArray()

ADOConnection::CacheGetAssoc()

ADOConnection::CacheGetCol()

ADOConnection::CacheGetOne()

ADOConnection::CacheGetRow()

ADOConnection::CachePageExecute()

Will select the supplied $page number from a recordset, given that it is paginated in pages of $nrows rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset. Added by Iván Oliva to provide recordset pagination.

ADOConnection::CacheSelectLimit()

Will select, getting rows from $offset (1-based), for $nrows.

ADOConnection::Close()

Close Connection

ADOConnection::CommitLock()

ADOConnection::CommitTrans()

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

ADOConnection::CompleteTrans()

ADOConnection::Concat()

Different SQL databases used different methods to combine strings together.

ADOConnection::Connect()

Connect to database

ADOConnection::CreateSequence()

ADOConnection::DBDate()

Converts a date "d" to a string that the database can understand.

ADOConnection::DBTimeStamp()

Converts a timestamp "ts" to a string that the database can understand.

ADOConnection::Disconnect()

PEAR DB Compat - do not use internally

ADOConnection::DropSequence()

ADOConnection::ErrorMsg()

ADOConnection::ErrorNative()

PEAR DB Compat - do not use internally.

ADOConnection::ErrorNo()

ADOConnection::escape()

ADOConnection::Execute()

Execute SQL

ADOConnection::FailTrans()

ADOConnection::GenID()

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

ADOConnection::GetActiveRecords()

ADOConnection::GetActiveRecordsClass()

ADOConnection::GetAll()

ADOConnection::GetArray()

ADOConnection::GetAssoc()

ADOConnection::GetCharSet()

ADOConnection::GetCol()

ADOConnection::GetInsertSQL()

Generates an Insert Query based on an existing recordset.

ADOConnection::GetOne()

Return first element of first row of sql statement. Recordset is disposed for you.

ADOConnection::GetRow()

Return one row of sql statement. Recordset is disposed for you.

ADOConnection::GetUpdateSQL()

Generates an Update Query based on an existing recordset.

ADOConnection::HasFailedTrans()

ADOConnection::IfNull()

ADOConnection::IgnoreErrors()

ADOConnection::InParameter()

ADOConnection::Insert_ID()

ADOConnection::IsConnected()

ADOConnection::LimitQuery()

PEAR DB Compat - do not use internally

ADOConnection::LogSQL()

ADOConnection::MetaColumnNames()

List columns names in a table as an array.

ADOConnection::MetaColumns()

List columns in a database as an array of ADOFieldObjects.

ADOConnection::MetaDatabases()

return the databases that the driver can connect to.

ADOConnection::MetaError()

ADOConnection::MetaErrorMsg()

ADOConnection::MetaForeignKeys()

ADOConnection::MetaIndexes()

List indexes on a table as an array.

ADOConnection::MetaPrimaryKeys()

ADOConnection::MetaTables()

ADOConnection::MetaTransaction()

ADOConnection::MetaType()

ADOConnection::NConnect()

Always force a new connection to database - currently only works with oracle

ADOConnection::nextId()

PEAR DB Compat - do not use internally.

ADOConnection::OffsetDate()

ADOConnection::outp()

All error messages go through this bottleneck function.

ADOConnection::OutParameter()

ADOConnection::PageExecute()

Will select the supplied $page number from a recordset, given that it is paginated in pages of $nrows rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset. Added by Iván Oliva to provide recordset pagination.

ADOConnection::Param()

ADOConnection::Parameter()

ADOConnection::PConnect()

Establish persistent connect to database

ADOConnection::PO_Insert_ID()

Portable Insert ID. Pablo Roca <pabloroca#mvps.org>

ADOConnection::Prepare()

Should prepare the sql statement and return the stmt resource.

ADOConnection::PrepareSP()

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

ADOConnection::q()

ADOConnection::QMagic()

ADOConnection::qstr()

Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes.

ADOConnection::Query()

PEAR DB Compat - do not use internally.

ADOConnection::Quote()

PEAR DB Compat

ADOConnection::Replace()

Insert or replace a single record. Note: this is not the same as MySQL's replace.

ADOConnection::RollbackLock()

ADOConnection::RollbackTrans()

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

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

ADOConnection::SelectDB()

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

ADOConnection::SelectLimit()

Will select, getting rows from $offset (1-based), for $nrows.

ADOConnection::SerializableRS()

Create serializable recordset. Breaks rs link to connection.

ADOConnection::ServerInfo()

ADOConnection::SetCharSet()

ADOConnection::SetDateLocale()

Change the SQL connection locale to a specified locale.

ADOConnection::SetFetchMode()

PEAR DB Compat - do not use internally.

ADOConnection::SetTransactionMode()

ADOConnection::SQLDate()

ADOConnection::StartTrans()

ADOConnection::Time()

ADOConnection::Transpose()

ADOConnection::UnixDate()

Also in ADORecordSet.

ADOConnection::UnixTimeStamp()

Also in ADORecordSet.

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.

ADOConnection::UpdateBlobFile()

Usage: UpdateBlob('TABLE', 'COLUMN', '/path/to/file', 'ID=1');

ADOConnection::UpdateClob()

Usage: UpdateClob('TABLE', 'COLUMN', $var, 'ID=1', 'CLOB');

ADOConnection::UserDate()

Also in ADORecordSet.

ADOConnection::UserTimeStamp()

ADOConnection::Version()

ADOConnection::xCacheFlush()

ADOConnection::_dirFlush()

Private function to erase all of the files and subdirectories in a directory.

ADOConnection::_Execute()

ADOConnection::_findschema()

ADOConnection::_findvers()

ADOConnection::_gencachename()

Private function to generate filename for caching.

ADOConnection::_nconnect()

ADOConnection::_rs2rs()

Convert database recordset to an array recordset input recordset's cursor should be at beginning, and old $rs will be closed.