ADODB_odbc_mssql Class Reference

Inheritance diagram for ADODB_odbc_mssql:

Public Member Functions
	__construct ()
	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, $owner=false)
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	SQLDate ($fmt, $col=false)
Public Member Functions inherited from ADODB_odbc
	__construct ()
	_connect ($argDSN, $argUsername, $argPassword, $argDatabasename)
	_pconnect ($argDSN, $argUsername, $argPassword, $argDatabasename)
	ServerInfo ()
	CreateSequence ($seqname='adodbseq', $start=1)
	DropSequence ($seqname='adodbseq')
	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 25 of file adodb-odbc_mssql.inc.php.

Constructor & Destructor Documentation

__construct()

ADODB_odbc_mssql::__construct

(

)

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

Member Function Documentation

_insertid()

ADODB_odbc_mssql::_insertid

(

)

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

_query()

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

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

References $sql, and ADODB_odbc\_query().

IfNull()

ADODB_odbc_mssql::IfNull	(		$field,
			$ifNull
	)

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

MetaColumns()

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

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

References $database, and $rs.

MetaForeignKeys()

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

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

References $a, and $sql.

MetaIndexes()

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

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

References $rs, and $sql.

MetaPrimaryKeys()

ADODB_odbc_mssql::MetaPrimaryKeys	(		$table,
			$owner = false
	)

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

References $a, and $sql.

MetaTables()

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

Definition at line 125 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 281 of file adodb-odbc_mssql.inc.php.

References $rs, and $sql.

ServerInfo()

ADODB_odbc_mssql::ServerInfo

(

)

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

SetTransactionMode()

ADODB_odbc_mssql::SetTransactionMode

(

$transaction_mode

)

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

SQLDate()

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

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

References $sysTimeStamp.

Member Data Documentation

$_bindInputArray

ADODB_odbc_mssql::$_bindInputArray = true

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

$ansiOuter

ADODB_odbc_mssql::$ansiOuter = true

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

$connectStmt

ADODB_odbc_mssql::$connectStmt = 'SET CONCAT_NULL_YIELDS_NULL OFF'

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

$databaseType

ADODB_odbc_mssql::$databaseType = 'odbc_mssql'

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

$fmtDate

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

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

$fmtTimeStamp

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

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

$hasInsertID

ADODB_odbc_mssql::$hasInsertID = true

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

$hasTop

ADODB_odbc_mssql::$hasTop = 'top'

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

$identitySQL

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

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

$leftOuter

ADODB_odbc_mssql::$leftOuter = '*='

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

$length

ADODB_odbc_mssql::$length = 'len'

Definition at line 43 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 32 of file adodb-odbc_mssql.inc.php.

$metaDatabasesSQL

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

Definition at line 30 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 31 of file adodb-odbc_mssql.inc.php.

Referenced by MetaTables().

$rightOuter

ADODB_odbc_mssql::$rightOuter = '=*'

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

$substr

ADODB_odbc_mssql::$substr = 'substring'

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

$sysDate

ADODB_odbc_mssql::$sysDate = 'GetDate()'

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

$sysTimeStamp

ADODB_odbc_mssql::$sysTimeStamp = 'GetDate()'

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

Referenced by SQLDate().