1 | <?php
|
---|
2 |
|
---|
3 |
|
---|
4 | /*
|
---|
5 | V4.94 23 Jan 2007 (c) 2000-2007 John Lim (jlim#natsoft.com.my). All rights reserved.
|
---|
6 | Released under both BSD license and Lesser GPL library license.
|
---|
7 | Whenever there is any discrepancy between the two licenses,
|
---|
8 | the BSD license will take precedence.
|
---|
9 | Set tabs to 8.
|
---|
10 |
|
---|
11 | */
|
---|
12 |
|
---|
13 | class ADODB_pdo_mssql extends ADODB_pdo {
|
---|
14 |
|
---|
15 | var $hasTop = 'top';
|
---|
16 | var $sysDate = 'convert(datetime,convert(char,GetDate(),102),102)';
|
---|
17 | var $sysTimeStamp = 'GetDate()';
|
---|
18 |
|
---|
19 |
|
---|
20 | function _init($parentDriver)
|
---|
21 | {
|
---|
22 |
|
---|
23 | $parentDriver->hasTransactions = false; ## <<< BUG IN PDO mssql driver
|
---|
24 | $parentDriver->_bindInputArray = false;
|
---|
25 | $parentDriver->hasInsertID = true;
|
---|
26 | }
|
---|
27 |
|
---|
28 | function ServerInfo()
|
---|
29 | {
|
---|
30 | return ADOConnection::ServerInfo();
|
---|
31 | }
|
---|
32 |
|
---|
33 | function SelectLimit($sql,$nrows=-1,$offset=-1,$inputarr=false,$secs2cache=0)
|
---|
34 | {
|
---|
35 | $ret = ADOConnection::SelectLimit($sql,$nrows,$offset,$inputarr,$secs2cache);
|
---|
36 | return $ret;
|
---|
37 | }
|
---|
38 |
|
---|
39 | function SetTransactionMode( $transaction_mode )
|
---|
40 | {
|
---|
41 | $this->_transmode = $transaction_mode;
|
---|
42 | if (empty($transaction_mode)) {
|
---|
43 | $this->Execute('SET TRANSACTION ISOLATION LEVEL READ COMMITTED');
|
---|
44 | return;
|
---|
45 | }
|
---|
46 | if (!stristr($transaction_mode,'isolation')) $transaction_mode = 'ISOLATION LEVEL '.$transaction_mode;
|
---|
47 | $this->Execute("SET TRANSACTION ".$transaction_mode);
|
---|
48 | }
|
---|
49 |
|
---|
50 | function MetaTables()
|
---|
51 | {
|
---|
52 | return false;
|
---|
53 | }
|
---|
54 |
|
---|
55 | function MetaColumns()
|
---|
56 | {
|
---|
57 | return false;
|
---|
58 | }
|
---|
59 |
|
---|
60 | }
|
---|
61 | ?> |
---|