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

Public Member Functions

Public Attributes