Docs For Class ADODB

Description

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

ADOConnection
   |
   --ADODB_mssql

Direct descendents

Class	Description
ADODB_mssqlpo

Variable Summary

mixed $ansiOuter

mixed $arrayClass

mixed $databaseType

mixed $dataProvider

mixed $fmtDate

mixed $fmtTimeStamp

mixed $hasAffectedRows

mixed $hasGenID

mixed $hasInsertID

mixed $hasTop

mixed $identitySQL

mixed $leftOuter

mixed $length

mixed $maxParameterLen

mixed $metaColumnsSQL

mixed $metaDatabasesSQL

mixed $metaTablesSQL

mixed $poorAffectedRows

mixed $replaceQuote

mixed $rightOuter

mixed $substr

mixed $sysDate

mixed $sysTimeStamp

mixed $uniqueOrderBy

mixed $uniqueSort

mixed $_bindInputArray

mixed $_dropSeqSQL

mixed $_has_mssql_init

Method Summary

ADODB_mssql ADODB_mssql ()

void BeginTrans ()

void CommitTrans ([ $ok = true])

void Concat ()

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

void ErrorMsg ()

void ErrorNo ()

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

void IfNull ( $field, $ifNull)

void MetaDatabases ()

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

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

void &MetaPrimaryKeys ( $table)

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

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

void Prepare ( $sql)

void PrepareSP ( $sql)

void RollbackTrans ()

void RowLock ( $tables, $where)

void SelectDB ( $dbName)

void &SelectLimit ( $sql, [ $nrows = -1], [ $offset = -1], [ $inputarr = false], [ $secs2cache = 0])

void ServerInfo ()

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

void UnixDate ( $v)

void UnixTimeStamp ( $v)

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

void _affectedrows ()

void _close ()

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

void _insertid ()

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

void _query ( $sql, $inputarr)

Variables

mixed $ansiOuter = true (line 100)

mixed $arrayClass = 'ADORecordSet_array_mssql' (line 96)

mixed $databaseType = "mssql" (line 74)

Redefined in descendants as:

ADODB_mssqlpo::$databaseType

mixed $dataProvider = "mssql" (line 75)

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

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

mixed $hasAffectedRows = true (line 82)

mixed $hasGenID = true (line 91)

mixed $hasInsertID = true (line 79)

mixed $hasTop = 'top' (line 90)

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

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

mixed $length = 'len' (line 81)

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)

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)

mixed $poorAffectedRows = true (line 101)

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

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

mixed $substr = "substring" (line 80)

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

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

mixed $uniqueOrderBy = true (line 103)

mixed $uniqueSort = true (line 97)

mixed $_bindInputArray = true (line 104)

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

mixed $_has_mssql_init (line 94)

Methods

Constructor ADODB_mssql (line 107)

ADODB_mssql ADODB_mssql ()

BeginTrans (line 273)

void BeginTrans ()

CommitTrans (line 281)

void CommitTrans ([ $ok = true])

$ok

Concat (line 542)

void Concat ()

CreateSequence (line 162)

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

$seq
$start

ErrorMsg (line 467)

void ErrorMsg ()

ErrorNo (line 475)

void ErrorNo ()

GenID (line 175)

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

$seq
$start

IfNull (line 140)

void IfNull ( $field, $ifNull)

$field
$ifNull

MetaDatabases (line 396)

void MetaDatabases ()

MetaForeignKeys (line 356)

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

$table
$owner
$upper

MetaIndexes (line 316)

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

$table
$primary

MetaPrimaryKeys (line 419)

void &MetaPrimaryKeys ( $table)

$table

MetaTables (line 443)

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

$ttype
$showSchema
$mask

Parameter (line 580)

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

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

Prepare (line 516)

void Prepare ( $sql)

$sql

PrepareSP (line 527)

void PrepareSP ( $sql)

$sql

Redefined in descendants as:

ADODB_mssqlpo::PrepareSP()

RollbackTrans (line 289)

void RollbackTrans ()

RowLock (line 309)

void RowLock ( $tables, $where)

$tables
$where

SelectDB (line 458)

void SelectDB ( $dbName)

$dbName

SelectLimit (line 199)

void &SelectLimit ( $sql, [ $nrows = -1], [ $offset = -1], [ $inputarr = false], $secs2cache)

$sql
$nrows
$offset
$inputarr
$secs2cache

ServerInfo (line 112)

void ServerInfo ()

SQLDate (line 213)

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

$fmt
$col

UnixDate (line 708)

void UnixDate ( $v)

$v

UnixTimeStamp (line 713)

void UnixTimeStamp ( $v)

$v

UpdateBlob (line 628)

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

$table
$column
$val
$where
$blobtype

_affectedrows (line 155)

void _affectedrows ()

_close (line 699)

void _close ()

_connect (line 490)

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

$argHostname
$argUsername
$argPassword
$argDatabasename

_insertid (line 145)

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

Class ADODB_mssql