$ssInsert_ID error
'; return false; } /** * Portable Insert ID. Pablo RocaAffected_Rows error
'; return false; } /** * @return the last error message */ function ErrorMsg() { return '!! '.strtoupper($this->dataProvider.' '.$this->databaseType).': '.$this->_errorMsg; } /** * @return the last error number. Normally 0 means no error. */ function ErrorNo() { return ($this->_errorMsg) ? -1 : 0; } /** * @returns an array with the primary key columns in it. */ function MetaPrimaryKeys($table) { return false; } /** * Choose a database to connect to. Many databases do not support this. * * @param dbName is the name of the database to select * @return true or false */ function SelectDB($dbName) {return false;} /** * Will select, getting rows from $offset (1-based), for $nrows. * This simulates the MySQL "select * from table limit $offset,$nrows" , and * the PostgreSQL "select * from table limit $nrows offset $offset". Note that * MySQL and PostgreSQL parameter ordering is the opposite of the other. * eg. * SelectLimit('select * from table',3); will return rows 1 to 3 (1-based) * SelectLimit('select * from table',3,2); will return rows 3 to 5 (1-based) * * Uses SELECT TOP for Microsoft databases, and FIRST_ROWS CBO hint for Oracle 8+ * BUG: Currently SelectLimit fails with $sql with LIMIT or TOP clause already set * * @param sql * @param [offset] is the row to start calculations from (1-based) * @param [rows] is the number of rows to get * @param [inputarr] array of bind variables * @param [arg3] is a private parameter only used by jlim * @param [secs2cache] is a private parameter only used by jlim * @return the recordset ($rs->databaseType == 'array') */ function &SelectLimit($sql,$nrows=-1,$offset=-1, $inputarr=false,$arg3=false,$secs2cache=0) { if ($this->hasTop && $nrows > 0) { // suggested by Reinhard Balling. Access requires top after distinct if ($offset <= 0) { $sql = preg_replace( '/(^select[\\t\\n ]*(distinctrow|distinct)?)/i','\\1 top '.$nrows.' ',$sql); if ($secs2cache>0) return $this->CacheExecute($secs2cache, $sql,$inputarr,$arg3); else return $this->Execute($sql,$inputarr,$arg3); } else { $nrows += $offset; $sql = preg_replace( '/(^select[\\t\\n ]*(distinctrow|distinct)?)/i','\\1 top '.$nrows.' ',$sql); $nrows = -1; } } if ($secs2cache>0) $rs = &$this->CacheExecute($secs2cache,$sql,$inputarr,$arg3); else $rs = &$this->Execute($sql,$inputarr,$arg3); if ($rs && !$rs->EOF) { return $this->_rs2rs($rs,$nrows,$offset); } //print_r($rs); return $rs; } /** * Convert recordset to an array recordset * input recordset's cursor should be at beginning, and * old $rs will be closed. * * @param rs the recordset to copy * @param [nrows] number of rows to retrieve (optional) * @param [offset] offset by number of rows (optional) * @return the new recordset */ function &_rs2rs(&$rs,$nrows=-1,$offset=-1) { $arr = &$rs->GetArrayLimit($nrows,$offset); $flds = array(); for ($i=0, $max=$rs->FieldCount(); $i < $max; $i++) $flds[] = &$rs->FetchField($i); $rs->Close(); $rs2 = new ADORecordSet_array(); $rs2->connection = &$this; $rs2->InitArrayFields($arr,$flds); return $rs2; } /** * Return first element of first row of sql statement. Recordset is disposed * for you. * * @param sql SQL statement * @param [inputarr] input bind array */ function GetOne($sql,$inputarr=false) { $ret = false; $rs = $this->Execute($sql,$inputarr); if ($rs) { if (!$rs->EOF) $ret = reset($rs->fields); $rs->Close(); } return $ret; } /** * Return all rows. Compat with PEAR DB * * @param sql SQL statement * @param [inputarr] input bind array */ function &GetAll($sql,$inputarr=false) { $rs = $this->Execute($sql,$inputarr); if (!$rs) if (defined('ADODB_PEAR')) return ADODB_PEAR_Error(); else return false; return $rs->GetArray(); } /** * Return one row of sql statement. Recordset is disposed for you. * * @param sql SQL statement * @param [inputarr] input bind array */ function GetRow($sql,$inputarr=false) { $rs = $this->Execute($sql,$inputarr); if ($rs) { $arr = false; if (!$rs->EOF) $arr = $rs->fields; $rs->Close(); return $arr; } return false; } /** * Will select, getting rows from $offset (1-based), for $nrows. * This simulates the MySQL "select * from table limit $offset,$nrows" , and * the PostgreSQL "select * from table limit $nrows offset $offset". Note that * MySQL and PostgreSQL parameter ordering is the opposite of the other. * eg. * CacheSelectLimit(15,'select * from table',3); will return rows 1 to 3 (1-based) * CacheSelectLimit(15,'select * from table',3,2); will return rows 3 to 5 (1-based) * * BUG: Currently CacheSelectLimit fails with $sql with LIMIT or TOP clause already set * * @param secs2cache seconds to cache data, set to 0 to force query * @param sql * @param [offset] is the row to start calculations from (1-based) * @param [nrows] is the number of rows to get * @param [inputarr] array of bind variables * @param [arg3] is a private parameter only used by jlim * @return the recordset ($rs->databaseType == 'array') */ function &CacheSelectLimit($secs2cache,$sql,$nrows=-1,$offset=-1,$inputarr=false, $arg3=false) { return $this->SelectLimit($sql,$nrows,$offset,$inputarr,$arg3,$secs2cache); } function CacheFlush($sql) { $f = $this->_gencachename($sql); adodb_write_file($f,''); // is adodb_write_file needed? @unlink($f); } function _gencachename($sql) { global $ADODB_CACHE_DIR; return $ADODB_CACHE_DIR.'/adodb_'.md5($sql.$this->databaseType.$this->database.$this->user).'.cache'; } /** * Execute SQL, caching recordsets. * * @param secs2cache seconds to cache data, set to 0 to force query * @param sql SQL statement to execute * @param [inputarr] holds the input data to bind to * @param [arg3] reserved for john lim for future use * @return RecordSet or false */ function &CacheExecute($secs2cache,$sql,$inputarr=false,$arg3=false) { include_once(ADODB_DIR.'/adodb-csvlib.inc.php'); // cannot cache if $inputarr set if ($inputarr) return $this->Execute($sql, $inputarr, $arg3); $md5file = $this->_gencachename($sql); $err = ''; if ($secs2cache > 0)$rs = &csv2rs($md5file,$err,$secs2cache); else { $err='Timeout 1'; $rs = false; } if (!$rs) { // no cached rs found if ($this->debug) print " $md5file cache failure: $err