<?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 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 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> <u>S</u>earch for </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 List</span></a></li> <li><a href="annotated.html"><span>Class List</span></a></li> <li><a href="hierarchy.html"><span>Class Hierarchy</span></a></li> <li><a href="functions.html"><span>Class 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="()" --> </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">& </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="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__oci805.html#0121f6d3f5bf99430df4c21e7365021a">$databaseType</a> = "oci805"</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="" --> </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">& ADODB_oci805::SelectLimit </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top">$ </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>$ </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>$ </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>$ </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>$ </td> <td class="mdname" nowrap> <em>secs2cache</em> = <code>0</code></td> </tr> <tr> <td class="md"></td> <td class="md">) </td> <td class="md" colspan="2"></td> </tr> </table> </td> </tr> </table> <table cellspacing="5" cellpadding="0" border="0"> <tr> <td> </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->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> </td><td></td></tr> <tr><td valign="top"></td><td valign="top"><em>[offset]</em> </td><td>is the row to start calculations from (1-based) </td></tr> <tr><td valign="top"></td><td valign="top"><em>[nrows]</em> </td><td>is the number of rows to get </td></tr> <tr><td valign="top"></td><td valign="top"><em>[inputarr]</em> </td><td>array of bind variables </td></tr> <tr><td valign="top"></td><td valign="top"><em>[secs2cache]</em> </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->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(); ?>