TYPO3 CMS  TYPO3_6-2
ADODB_odbc_mssql Class Reference
Inheritance diagram for ADODB_odbc_mssql:
ADODB_odbc

Public Member Functions

 ADODB_odbc_mssql ()
 
 ServerInfo ()
 
 IfNull ( $field, $ifNull)
 
 _insertid ()
 
 MetaForeignKeys ($table, $owner=false, $upper=false)
 
 MetaTables ($ttype=false, $showSchema=false, $mask=false)
 
 MetaColumns ($table, $normalize=true)
 
 MetaIndexes ($table, $primary=false, $owner=false)
 
 _query ($sql, $inputarr=false)
 
 SetTransactionMode ( $transaction_mode)
 
 MetaPrimaryKeys ($table)
 
 SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
 
 SQLDate ($fmt, $col=false)
 
- Public Member Functions inherited from ADODB_odbc
 ADODB_odbc ()
 
 _connect ($argDSN, $argUsername, $argPassword, $argDatabasename)
 
 _pconnect ($argDSN, $argUsername, $argPassword, $argDatabasename)
 
 ServerInfo ()
 
 CreateSequence ($seqname='adodbseq', $start=1)
 
 DropSequence ($seqname)
 
 GenID ($seq='adodbseq', $start=1)
 
 ErrorMsg ()
 
 ErrorNo ()
 
 BeginTrans ()
 
 CommitTrans ($ok=true)
 
 RollbackTrans ()
 
 MetaPrimaryKeys ($table, $owner=false)
 
 MetaTables ($ttype=false, $showSchema=false, $mask=false)
 
 ODBCTypes ($t)
 
 MetaColumns ($table, $normalize=true)
 
 Prepare ($sql)
 
 _query ($sql, $inputarr=false)
 
 UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')
 
 _close ()
 
 _affectedrows ()
 

Public Attributes

 $databaseType = 'odbc_mssql'
 
 $fmtDate = "'Y-m-d'"
 
 $fmtTimeStamp = "'Y-m-d\TH:i:s'"
 
 $_bindInputArray = true
 
 $metaDatabasesSQL = "select name from sysdatabases where name <> 'master'"
 
 $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'))"
 
 $metaColumnsSQL
 
 $hasTop = 'top'
 
 $sysDate = 'GetDate()'
 
 $sysTimeStamp = 'GetDate()'
 
 $leftOuter = '*='
 
 $rightOuter = '=*'
 
 $substr = 'substring'
 
 $length = 'len'
 
 $ansiOuter = true
 
 $identitySQL = 'select SCOPE_IDENTITY()'
 
 $hasInsertID = true
 
 $connectStmt = 'SET CONCAT_NULL_YIELDS_NULL OFF'
 
- Public Attributes inherited from ADODB_odbc
 $databaseType = "odbc"
 
 $fmtDate = "'Y-m-d'"
 
 $fmtTimeStamp = "'Y-m-d, h:i:sA'"
 
 $replaceQuote = "''"
 
 $dataProvider = "odbc"
 
 $hasAffectedRows = true
 
 $binmode = ODBC_BINMODE_RETURN
 
 $useFetchArray = false
 
 $_bindInputArray = false
 
 $curmode = SQL_CUR_USE_DRIVER
 
 $_genSeqSQL = "create table %s (id integer)"
 
 $_autocommit = true
 
 $_haserrorfunctions = true
 
 $_has_stupid_odbc_fetch_api_change = true
 
 $_lastAffectedRows = 0
 
 $uCaseTables = true
 
 $_dropSeqSQL = 'drop table %s'
 

Detailed Description

Definition at line 23 of file adodb-odbc_mssql.inc.php.

Member Function Documentation

◆ _insertid()

ADODB_odbc_mssql::_insertid ( )

Definition at line 73 of file adodb-odbc_mssql.inc.php.

◆ _query()

ADODB_odbc_mssql::_query (   $sql,
  $inputarr = false 
)

Definition at line 236 of file adodb-odbc_mssql.inc.php.

References $sql, and ADODB_odbc\_query().

◆ ADODB_odbc_mssql()

ADODB_odbc_mssql::ADODB_odbc_mssql ( )

Definition at line 48 of file adodb-odbc_mssql.inc.php.

References ADODB_odbc\ADODB_odbc().

◆ IfNull()

ADODB_odbc_mssql::IfNull (   $field,
  $ifNull 
)

Definition at line 68 of file adodb-odbc_mssql.inc.php.

◆ MetaColumns()

ADODB_odbc_mssql::MetaColumns (   $table,
  $normalize = true 
)

Definition at line 138 of file adodb-odbc_mssql.inc.php.

References $database, and $rs.

◆ MetaForeignKeys()

ADODB_odbc_mssql::MetaForeignKeys (   $table,
  $owner = false,
  $upper = false 
)

Definition at line 84 of file adodb-odbc_mssql.inc.php.

References $sql.

◆ MetaIndexes()

ADODB_odbc_mssql::MetaIndexes (   $table,
  $primary = false,
  $owner = false 
)

Definition at line 196 of file adodb-odbc_mssql.inc.php.

References $rs, and $sql.

◆ MetaPrimaryKeys()

ADODB_odbc_mssql::MetaPrimaryKeys (   $table)

Definition at line 255 of file adodb-odbc_mssql.inc.php.

References $sql.

◆ MetaTables()

ADODB_odbc_mssql::MetaTables (   $ttype = false,
  $showSchema = false,
  $mask = false 
)

Definition at line 123 of file adodb-odbc_mssql.inc.php.

References $metaTablesSQL.

◆ SelectLimit()

ADODB_odbc_mssql::SelectLimit (   $sql,
  $nrows = -1,
  $offset = -1,
  $inputarr = false,
  $secs2cache = 0 
)

Definition at line 279 of file adodb-odbc_mssql.inc.php.

References $rs, and $sql.

◆ ServerInfo()

ADODB_odbc_mssql::ServerInfo ( )

Definition at line 55 of file adodb-odbc_mssql.inc.php.

◆ SetTransactionMode()

ADODB_odbc_mssql::SetTransactionMode (   $transaction_mode)

Definition at line 242 of file adodb-odbc_mssql.inc.php.

◆ SQLDate()

ADODB_odbc_mssql::SQLDate (   $fmt,
  $col = false 
)

Definition at line 292 of file adodb-odbc_mssql.inc.php.

References $sysTimeStamp.

Member Data Documentation

◆ $_bindInputArray

ADODB_odbc_mssql::$_bindInputArray = true

Definition at line 27 of file adodb-odbc_mssql.inc.php.

◆ $ansiOuter

ADODB_odbc_mssql::$ansiOuter = true

Definition at line 42 of file adodb-odbc_mssql.inc.php.

◆ $connectStmt

ADODB_odbc_mssql::$connectStmt = 'SET CONCAT_NULL_YIELDS_NULL OFF'

Definition at line 45 of file adodb-odbc_mssql.inc.php.

◆ $databaseType

ADODB_odbc_mssql::$databaseType = 'odbc_mssql'

Definition at line 24 of file adodb-odbc_mssql.inc.php.

◆ $fmtDate

ADODB_odbc_mssql::$fmtDate = "'Y-m-d'"

Definition at line 25 of file adodb-odbc_mssql.inc.php.

◆ $fmtTimeStamp

ADODB_odbc_mssql::$fmtTimeStamp = "'Y-m-d\TH:i:s'"

Definition at line 26 of file adodb-odbc_mssql.inc.php.

◆ $hasInsertID

ADODB_odbc_mssql::$hasInsertID = true

Definition at line 44 of file adodb-odbc_mssql.inc.php.

◆ $hasTop

ADODB_odbc_mssql::$hasTop = 'top'

Definition at line 35 of file adodb-odbc_mssql.inc.php.

◆ $identitySQL

ADODB_odbc_mssql::$identitySQL = 'select SCOPE_IDENTITY()'

Definition at line 43 of file adodb-odbc_mssql.inc.php.

◆ $leftOuter

ADODB_odbc_mssql::$leftOuter = '*='

Definition at line 38 of file adodb-odbc_mssql.inc.php.

◆ $length

ADODB_odbc_mssql::$length = 'len'

Definition at line 41 of file adodb-odbc_mssql.inc.php.

◆ $metaColumnsSQL

ADODB_odbc_mssql::$metaColumnsSQL
Initial value:
= # xtype==61 is datetime
"select c.name,t.name,c.length,c.isnullable, c.status,
(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'"

Definition at line 30 of file adodb-odbc_mssql.inc.php.

◆ $metaDatabasesSQL

ADODB_odbc_mssql::$metaDatabasesSQL = "select name from sysdatabases where name <> 'master'"

Definition at line 28 of file adodb-odbc_mssql.inc.php.

◆ $metaTablesSQL

ADODB_odbc_mssql::$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'))"

Definition at line 29 of file adodb-odbc_mssql.inc.php.

Referenced by MetaTables().

◆ $rightOuter

ADODB_odbc_mssql::$rightOuter = '=*'

Definition at line 39 of file adodb-odbc_mssql.inc.php.

◆ $substr

ADODB_odbc_mssql::$substr = 'substring'

Definition at line 40 of file adodb-odbc_mssql.inc.php.

◆ $sysDate

ADODB_odbc_mssql::$sysDate = 'GetDate()'

Definition at line 36 of file adodb-odbc_mssql.inc.php.

◆ $sysTimeStamp

ADODB_odbc_mssql::$sysTimeStamp = 'GetDate()'

Definition at line 37 of file adodb-odbc_mssql.inc.php.

Referenced by SQLDate().