diff options
Diffstat (limited to 'codebase/db_mssql.php')
-rw-r--r-- | codebase/db_mssql.php | 73 |
1 files changed, 0 insertions, 73 deletions
diff --git a/codebase/db_mssql.php b/codebase/db_mssql.php deleted file mode 100644 index 0acab93..0000000 --- a/codebase/db_mssql.php +++ /dev/null @@ -1,73 +0,0 @@ -<?php -/* - @author dhtmlx.com - @license GPL, see license.txt -*/ -require_once("db_common.php"); -/*! MSSQL implementation of DataWrapper -**/ -class MsSQLDBDataWrapper extends DBDataWrapper{ - private $last_id=""; //!< ID of previously inserted record - private $insert_operation=false; //!< flag of insert operation - private $start_from=false; //!< index of start position - - public function query($sql){ - LogMaster::log($sql); - $res = mssql_query($sql,$this->connection); - if ($this->insert_operation){ - $last = mssql_fetch_assoc($res); - $this->last_id = $last["dhx_id"]; - mssql_free_result($res); - } - if ($this->start_from) - mssql_data_seek($res,$this->start_from); - return $res; - } - - public function get_next($res){ - return mssql_fetch_assoc($res); - } - - public function get_new_id(){ - /* - MSSQL doesn't support identity or auto-increment fields - Insert SQL returns new ID value, which stored in last_id field - */ - return $this->last_id; - } - - protected function insert_query($data,$request){ - $sql = parent::insert_query($data,$request); - $this->insert_operation=true; - return $sql.";SELECT @@IDENTITY AS dhx_id"; - } - - protected function select_query($select,$from,$where,$sort,$start,$count){ - if (!$from) - return $select; - - $sql="SELECT " ; - if ($count) - $sql.=" TOP ".($count+$start); - $sql.=" ".$select." FROM ".$from; - if ($where) $sql.=" WHERE ".$where; - if ($sort) $sql.=" ORDER BY ".$sort; - if ($start && $count) - $this->start_from=$start; - else - $this->start_from=false; - return $sql; - } - - public function escape($data){ - /* - there is no special escaping method for mssql - use common logic - */ - return str_replace("'","''",$data); - } - - public function begin_transaction(){ - $this->query("BEGIN TRAN"); - } -} -?>
\ No newline at end of file |