<?php
  include_once '../doc-typo3-funcs.php';
  $doxygen_vars = array(	"title" => "TYPO3 4.0.1: ADODB_oci805 Class Reference",
				"datetime" => "Sat Dec 2 19:23:25 2006",
				"date" => "2 Dec 2006",
				"doxygenversion" => "1.4.6",
				"projectname" => "TYPO3 4.0.1",
				"projectnumber" => "4.0.1"
			);
  get_header($doxygen_vars);
?>
<!-- Generated by Doxygen 1.4.6 -->
<div class="tabs">
  <ul>
    <li><a href="main.html"><span>Main&nbsp;Page</span></a></li>
    <li><a href="namespaces.html"><span>Namespaces</span></a></li>
    <li id="current"><a href="classes.html"><span>Classes</span></a></li>
    <li><a href="files.html"><span>Files</span></a></li>
    <li><a href="dirs.html"><span>Directories</span></a></li>
    <li><a href="pages.html"><span>Related&nbsp;Pages</span></a></li>
    <li><a href="examples.html"><span>Examples</span></a></li>
    <li>
      <form action="search.php" method="get">
        <table cellspacing="0" cellpadding="0" border="0">
          <tr>
            <td><label>&nbsp;<u>S</u>earch&nbsp;for&nbsp;</label></td>
            <td><input type="text" name="query" value="" size="20" accesskey="s"/></td>
          </tr>
        </table>
      </form>
    </li>
  </ul></div>
<div class="tabs">
  <ul>
    <li><a href="classes.html"><span>Alphabetical&nbsp;List</span></a></li>
    <li><a href="annotated.html"><span>Class&nbsp;List</span></a></li>
    <li><a href="hierarchy.html"><span>Class&nbsp;Hierarchy</span></a></li>
    <li><a href="functions.html"><span>Class&nbsp;Members</span></a></li>
  </ul></div>
<h1>ADODB_oci805 Class Reference</h1><!-- doxytag: class="ADODB_oci805" --><!-- doxytag: inherits="ADODB_oci8" -->Inheritance diagram for ADODB_oci805:<p><center><img src="classADODB__oci805__inherit__graph.png" border="0" usemap="#ADODB__oci805__inherit__map" alt="Inheritance graph"></center>
<map name="ADODB__oci805__inherit__map">
<area href="classADODB__oci8.html" shape="rect" coords="5,5,227,1093" alt="">
</map>
<center><font size="2">[<a target="top" href="graph_legend.html">legend</a>]</font></center>Collaboration diagram for ADODB_oci805:<p><center><img src="classADODB__oci805__coll__graph.png" border="0" usemap="#ADODB__oci805__coll__map" alt="Collaboration graph"></center>
<map name="ADODB__oci805__coll__map">
<area href="classADODB__oci8.html" shape="rect" coords="5,5,227,1093" alt="">
</map>
<center><font size="2">[<a target="top" href="graph_legend.html">legend</a>]</font></center><a href="classADODB__oci805-members.html">List of all members.</a><table border="0" cellpadding="0" cellspacing="0">
<tr><td></td></tr>
<tr><td colspan="2"><br><h2>Public Member Functions</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="1d5077cb4c27ec069f720a522953021c"></a><!-- doxytag: member="ADODB_oci805::ADODB_oci805" ref="1d5077cb4c27ec069f720a522953021c" args="()" -->
&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__oci805.html#1d5077cb4c27ec069f720a522953021c">ADODB_oci805</a> ()</td></tr>

<tr><td class="memItemLeft" nowrap align="right" valign="top">&amp;&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__oci805.html#d3e0216e75eafa0c4aee542f4813f89e">SelectLimit</a> ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)</td></tr>

<tr><td colspan="2"><br><h2>Public Attributes</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="0121f6d3f5bf99430df4c21e7365021a"></a><!-- doxytag: member="ADODB_oci805::$databaseType" ref="0121f6d3f5bf99430df4c21e7365021a" args="" -->
&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__oci805.html#0121f6d3f5bf99430df4c21e7365021a">$databaseType</a> = &quot;oci805&quot;</td></tr>

<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="52ca0e8327f8db8538bba4f178f8d929"></a><!-- doxytag: member="ADODB_oci805::$connectSID" ref="52ca0e8327f8db8538bba4f178f8d929" args="" -->
&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__oci805.html#52ca0e8327f8db8538bba4f178f8d929">$connectSID</a> = true</td></tr>

</table>
<hr><a name="_details"></a><h2>Detailed Description</h2>

<p>

<p>
Definition at line <a class="el" href="adodb-oci805_8inc_8php-source.html#l00020">20</a> of file <a class="el" href="adodb-oci805_8inc_8php-source.html">adodb-oci805.inc.php</a>.<hr><h2>Member Function Documentation</h2>
<a class="anchor" name="d3e0216e75eafa0c4aee542f4813f89e"></a><!-- doxytag: member="ADODB_oci805::SelectLimit" ref="d3e0216e75eafa0c4aee542f4813f89e" args="($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)" --><p>
<table class="mdTable" cellpadding="2" cellspacing="0">
  <tr>
    <td class="mdRow">
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td class="md" nowrap valign="top">&amp; ADODB_oci805::SelectLimit           </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">$&nbsp;</td>
          <td class="mdname" nowrap> <em>sql</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td class="md"></td>
          <td class="md" nowrap>$&nbsp;</td>
          <td class="mdname" nowrap> <em>nrows</em> = <code>-1</code>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td class="md"></td>
          <td class="md" nowrap>$&nbsp;</td>
          <td class="mdname" nowrap> <em>offset</em> = <code>-1</code>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td class="md"></td>
          <td class="md" nowrap>$&nbsp;</td>
          <td class="mdname" nowrap> <em>inputarr</em> = <code>false</code>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td class="md"></td>
          <td class="md" nowrap>$&nbsp;</td>
          <td class="mdname" nowrap> <em>secs2cache</em> = <code>0</code></td>
        </tr>
        <tr>
          <td class="md"></td>
          <td class="md">)&nbsp;</td>
          <td class="md" colspan="2"></td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<table cellspacing="5" cellpadding="0" border="0">
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
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)<p>
Uses SELECT TOP for Microsoft databases (when $this-&gt;hasTop is set) BUG: Currently SelectLimit fails with $sql with LIMIT or TOP clause already set<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>sql</em>&nbsp;</td><td></td></tr>
    <tr><td valign="top"></td><td valign="top"><em>[offset]</em>&nbsp;</td><td>is the row to start calculations from (1-based) </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>[nrows]</em>&nbsp;</td><td>is the number of rows to get </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>[inputarr]</em>&nbsp;</td><td>array of bind variables </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>[secs2cache]</em>&nbsp;</td><td>is a private parameter only used by jlim </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>the recordset ($rs-&gt;databaseType == 'array') </dd></dl>

<p>
Reimplemented from <a class="el" href="classADODB__oci8.html#6eaf1680d7efa562701e5143aff0ce5a">ADODB_oci8</a>.
<p>
Definition at line <a class="el" href="adodb-oci805_8inc_8php-source.html#l00029">29</a> of file <a class="el" href="adodb-oci805_8inc_8php-source.html">adodb-oci805.inc.php</a>.
<p>
References <a class="el" href="adodb_8inc_8php-source.html#l01102">ADOConnection::SelectLimit()</a>.    </td>
  </tr>
</table>
<hr>The documentation for this class was generated from the following file:<ul>
<li>typo3_src-4.0.1/typo3/sysext/adodb/adodb/drivers/<a class="el" href="adodb-oci805_8inc_8php-source.html">adodb-oci805.inc.php</a></ul>
<?php
  include_once '../doc-typo3-funcs.php';
  get_footer();
?>