Inheritance diagram for ADODB_odbc_mssql:

Collaboration diagram for ADODB_odbc_mssql:

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 Attributes
	$databaseType = 'odbc_mssql'
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d H: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 = "select c.name,t.name,c.length from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s'"
	$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'

Detailed Description

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

Member Function Documentation

ADODB_odbc_mssql::_insertid ( )

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

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

Reimplemented from ADODB_odbc.

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

References $sql.

ADODB_odbc_mssql::ADODB_odbc_mssql ( )

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

References ADODB_odbc::ADODB_odbc().

Here is the call graph for this function:

ADODB_odbc_mssql::IfNull	(	$	field,
		$	ifNull
	)

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

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

Reimplemented from ADODB_odbc.

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

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

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

References $sql.

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

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

References $row, $rs, and $sql.

ADODB_odbc_mssql::MetaPrimaryKeys ( $ table )

Reimplemented from ADODB_odbc.

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

References $sql.

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

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

References debug().

Here is the call graph for this function:

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

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

References $rs, and $sql.

ADODB_odbc_mssql::ServerInfo ( )

Reimplemented from ADODB_odbc.

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

References $row.

ADODB_odbc_mssql::SetTransactionMode ( $ transaction_mode )

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

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

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

Member Data Documentation

ADODB_odbc_mssql::$_bindInputArray = true

Reimplemented from ADODB_odbc.

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

ADODB_odbc_mssql::$ansiOuter = true

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

ADODB_odbc_mssql::$connectStmt = 'SET CONCAT_NULL_YIELDS_NULL OFF'

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

ADODB_odbc_mssql::$databaseType = 'odbc_mssql'

Reimplemented from ADODB_odbc.

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

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

Reimplemented from ADODB_odbc.

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

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

Reimplemented from ADODB_odbc.

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

ADODB_odbc_mssql::$hasInsertID = true

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

ADODB_odbc_mssql::$hasTop = 'top'

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

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

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

ADODB_odbc_mssql::$leftOuter = '*='

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

ADODB_odbc_mssql::$length = 'len'

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

ADODB_odbc_mssql::$metaColumnsSQL = "select c.name,t.name,c.length 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.

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

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

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.

ADODB_odbc_mssql::$rightOuter = '=*'

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

ADODB_odbc_mssql::$substr = 'substring'

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

ADODB_odbc_mssql::$sysDate = 'GetDate()'

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

ADODB_odbc_mssql::$sysTimeStamp = 'GetDate()'

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

The documentation for this class was generated from the following file:

typo3/sysext/adodb/adodb/drivers/adodb-odbc_mssql.inc.php

ADODB_odbc_mssql Class Reference

Public Member Functions

Public Attributes

Detailed Description

Member Function Documentation

Member Data Documentation