From 1f8410794c8213d87227fabae2114a3be8033ece Mon Sep 17 00:00:00 2001 From: wei <> Date: Thu, 18 May 2006 08:16:21 +0000 Subject: Moved adodb to 3rdParty directory. --- .../3rdParty/adodb/drivers/adodb-oci805.inc.php | 59 ++++++++++++++++++++++ 1 file changed, 59 insertions(+) create mode 100644 framework/3rdParty/adodb/drivers/adodb-oci805.inc.php (limited to 'framework/3rdParty/adodb/drivers/adodb-oci805.inc.php') diff --git a/framework/3rdParty/adodb/drivers/adodb-oci805.inc.php b/framework/3rdParty/adodb/drivers/adodb-oci805.inc.php new file mode 100644 index 00000000..5163df09 --- /dev/null +++ b/framework/3rdParty/adodb/drivers/adodb-oci805.inc.php @@ -0,0 +1,59 @@ +ADODB_oci8(); + } + + function &SelectLimit($sql,$nrows=-1,$offset=-1, $inputarr=false,$secs2cache=0) + { + // seems that oracle only supports 1 hint comment in 8i + if (strpos($sql,'/*+') !== false) + $sql = str_replace('/*+ ','/*+FIRST_ROWS ',$sql); + else + $sql = preg_replace('/^[ \t\n]*select/i','SELECT /*+FIRST_ROWS*/',$sql); + + /* + The following is only available from 8.1.5 because order by in inline views not + available before then... + http://www.jlcomp.demon.co.uk/faq/top_sql.html + if ($nrows > 0) { + if ($offset > 0) $nrows += $offset; + $sql = "select * from ($sql) where rownum <= $nrows"; + $nrows = -1; + } + */ + + return ADOConnection::SelectLimit($sql,$nrows,$offset,$inputarr,$secs2cache); + } +} + +class ADORecordset_oci805 extends ADORecordset_oci8 { + var $databaseType = "oci805"; + function ADORecordset_oci805($id,$mode=false) + { + $this->ADORecordset_oci8($id,$mode); + } +} +?> \ No newline at end of file -- cgit v1.2.3