Public Member Functions | |
| ADODB_ado_mssql () | |
| _insertid () | |
| _affectedrows () | |
| SetTransactionMode ($transaction_mode) | |
| qstr ($s, $magic_quotes=false) | |
| MetaColumns ($table) | |
| CreateSequence ($seq='adodbseq', $start=1) | |
| GenID ($seq='adodbseq', $start=1) | |
Public Attributes | |
| $databaseType = 'ado_mssql' | |
| $hasTop = 'top' | |
| supports affected rows for update/delete? | |
| $hasInsertID = true | |
| $sysDate = 'convert(datetime,convert(char,GetDate(),102),102)' | |
| Use 'true' to store the item compressed (uses zlib). | |
| $sysTimeStamp = 'GetDate()' | |
| name of function that returns the current date | |
| $leftOuter = '*=' | |
| indicates that all fields in order by must be unique | |
| $rightOuter = '=*' | |
| operator to use for left outer join in WHERE clause | |
| $ansiOuter = true | |
| operator to use for right outer join in WHERE clause | |
| $substr = "substring" | |
| default concat operator -- change to || for Oracle/Interbase | |
| $length = 'len' | |
| substring operator | |
| $_dropSeqSQL = "drop table %s" | |
Definition at line 27 of file adodb-ado_mssql.inc.php.
| ADODB_ado_mssql::qstr | ( | $ | s, | |
| $ | magic_quotes = false | |||
| ) |
Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes. An example is $db->qstr("Don't bother",magic_quotes_runtime());
| s | the string to quote | |
| [magic_quotes] | if $s is GET/POST var, set to get_magic_quotes_gpc(). This undoes the stupidity of magic quotes for GPC. |
Reimplemented from ADOConnection.
Definition at line 68 of file adodb-ado_mssql.inc.php.
| ADODB_ado_mssql::GenID | ( | $ | seqname = 'adodbseq', |
|
| $ | startID = 1 | |||
| ) |
Generates a sequence id and stores it in $this->genID; GenID is only available if $this->hasGenID = true;
| seqname | name of sequence to use | |
| startID | if sequence does not exist, start at this ID |
Reimplemented from ADOConnection.
Definition at line 120 of file adodb-ado_mssql.inc.php.