<?php
include_once '../doc-typo3-funcs.php';
$doxygen_vars = array( "title" => "TYPO3 4.0.1: ADODB_vfp Class Reference",
"datetime" => "Sat Dec 2 19:24:03 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_vfp Class Reference</h1><!-- doxytag: class="ADODB_vfp" --><!-- doxytag: inherits="ADODB_odbc" -->Inheritance diagram for ADODB_vfp:<p><center><img src="classADODB__vfp__inherit__graph.png" border="0" usemap="#ADODB__vfp__inherit__map" alt="Inheritance graph"></center>
<map name="ADODB__vfp__inherit__map">
<area href="classADODB__odbc.html" shape="rect" coords="5,7,264,609" alt="">
</map>
<center><font size="2">[<a target="top" href="graph_legend.html">legend</a>]</font></center>Collaboration diagram for ADODB_vfp:<p><center><img src="classADODB__vfp__coll__graph.png" border="0" usemap="#ADODB__vfp__coll__map" alt="Collaboration graph"></center>
<map name="ADODB__vfp__coll__map">
<area href="classADODB__odbc.html" shape="rect" coords="5,7,264,609" alt="">
</map>
<center><font size="2">[<a target="top" href="graph_legend.html">legend</a>]</font></center><a href="classADODB__vfp-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="d9442f5eb120995edc822adba0bdace4"></a><!-- doxytag: member="ADODB_vfp::ADODB_vfp" ref="d9442f5eb120995edc822adba0bdace4" args="()" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#d9442f5eb120995edc822adba0bdace4">ADODB_vfp</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="7885e0f8806f991afa7d7826f56c0ee4"></a><!-- doxytag: member="ADODB_vfp::Time" ref="7885e0f8806f991afa7d7826f56c0ee4" args="()" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#7885e0f8806f991afa7d7826f56c0ee4">Time</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#e90df04fd50cb425f9d9336813899f9c">BeginTrans</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#727e7bfb0f7f07bdc6fb4e9314357265">qstr</a> ($s, $nofixquotes=false)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">& </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#4aa918468ea5ad53609f457f627f7954">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="57df1d978e4288760274bdf63d24f0c5"></a><!-- doxytag: member="ADODB_vfp::$databaseType" ref="57df1d978e4288760274bdf63d24f0c5" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#57df1d978e4288760274bdf63d24f0c5">$databaseType</a> = "vfp"</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="7483b7bff8cbfd1399f08300b4aeff72"></a><!-- doxytag: member="ADODB_vfp::$fmtDate" ref="7483b7bff8cbfd1399f08300b4aeff72" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#7483b7bff8cbfd1399f08300b4aeff72">$fmtDate</a> = "{^Y-m-d}"</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">uppercase function <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="fcdd4d0e0b83121d082b4765ba6656d5"></a><!-- doxytag: member="ADODB_vfp::$fmtTimeStamp" ref="fcdd4d0e0b83121d082b4765ba6656d5" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#fcdd4d0e0b83121d082b4765ba6656d5">$fmtTimeStamp</a> = "{^Y-m-d, h:i:sA}"</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">used by <a class="el" href="classADOConnection.html#cb3116e6c17d7d43e8104df34aef3066">DBDate()</a> as the default date format used by the database <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="078bb917145c73ac096e2c070375a932"></a><!-- doxytag: member="ADODB_vfp::$replaceQuote" ref="078bb917145c73ac096e2c070375a932" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#078bb917145c73ac096e2c070375a932">$replaceQuote</a> = "'+chr(39)+'"</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">string that represents FALSE for a database <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="0b1c220e376a023069ea7df7ab156e18"></a><!-- doxytag: member="ADODB_vfp::$true" ref="0b1c220e376a023069ea7df7ab156e18" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#0b1c220e376a023069ea7df7ab156e18">$true</a> = '.T.'</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">used by DBTimeStamp as the default timestamp fmt. <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="d97c09b30e557cc03c95e73cc3c325d4"></a><!-- doxytag: member="ADODB_vfp::$false" ref="d97c09b30e557cc03c95e73cc3c325d4" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#d97c09b30e557cc03c95e73cc3c325d4">$false</a> = '.F.'</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">string that represents TRUE for a database <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="c752e5ac81995b14c4427d57b9c1c435"></a><!-- doxytag: member="ADODB_vfp::$hasTop" ref="c752e5ac81995b14c4427d57b9c1c435" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#c752e5ac81995b14c4427d57b9c1c435">$hasTop</a> = 'top'</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">supports affected rows for update/delete? <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="e8446ae2cacaedd36d9d4363d7ad42c8"></a><!-- doxytag: member="ADODB_vfp::$_bindInputArray" ref="e8446ae2cacaedd36d9d4363d7ad42c8" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#e8446ae2cacaedd36d9d4363d7ad42c8">$_bindInputArray</a> = false</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">A boolean variable to state whether its a persistent connection or normal connection. */. <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="7dab33a27a9c8657b03dd72984a797f1"></a><!-- doxytag: member="ADODB_vfp::$sysTimeStamp" ref="7dab33a27a9c8657b03dd72984a797f1" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#7dab33a27a9c8657b03dd72984a797f1">$sysTimeStamp</a> = 'datetime()'</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">name of function that returns the current date <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="4e45e0e8e080ca7b7379b88d37f119eb"></a><!-- doxytag: member="ADODB_vfp::$sysDate" ref="4e45e0e8e080ca7b7379b88d37f119eb" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#4e45e0e8e080ca7b7379b88d37f119eb">$sysDate</a> = 'date()'</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">cache for 1 hour <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="7600ab0a941c1ce176182b5c2a939f2c"></a><!-- doxytag: member="ADODB_vfp::$ansiOuter" ref="7600ab0a941c1ce176182b5c2a939f2c" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#7600ab0a941c1ce176182b5c2a939f2c">$ansiOuter</a> = true</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">operator to use for right outer join in WHERE clause <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="2ed650c04a7864252b4b5dc6b94eb41b"></a><!-- doxytag: member="ADODB_vfp::$hasTransactions" ref="2ed650c04a7864252b4b5dc6b94eb41b" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#2ed650c04a7864252b4b5dc6b94eb41b">$hasTransactions</a> = false</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">can generate sequences using <a class="el" href="classADODB__odbc.html#e8045867b94d81eb0feedbeb387895a9">GenID()</a>; <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="1d1fb44de4d0d31b93832c265a46024f"></a><!-- doxytag: member="ADODB_vfp::$curmode" ref="1d1fb44de4d0d31b93832c265a46024f" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__vfp.html#1d1fb44de4d0d31b93832c265a46024f">$curmode</a> = false</td></tr>
</table>
<hr><a name="_details"></a><h2>Detailed Description</h2>
<p>
<p>
Definition at line <a class="el" href="adodb-vfp_8inc_8php-source.html#l00022">22</a> of file <a class="el" href="adodb-vfp_8inc_8php-source.html">adodb-vfp.inc.php</a>.<hr><h2>Member Function Documentation</h2>
<a class="anchor" name="e90df04fd50cb425f9d9336813899f9c"></a><!-- doxytag: member="ADODB_vfp::BeginTrans" ref="e90df04fd50cb425f9d9336813899f9c" args="()" --><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_vfp::BeginTrans </td>
<td class="md" valign="top">( </td>
<td class="mdname1" valign="top" nowrap> </td>
<td class="md" valign="top"> ) </td>
<td class="md" nowrap></td>
</tr>
</table>
</td>
</tr>
</table>
<table cellspacing="5" cellpadding="0" border="0">
<tr>
<td>
</td>
<td>
<p>
Begin a Transaction. Must be followed by <a class="el" href="classADODB__odbc.html#0af9469a4fd66444d415e20842e5740b">CommitTrans()</a> or <a class="el" href="classADODB__odbc.html#fa3ec395a4c1dc3ca2882ed1c67aaad9">RollbackTrans()</a>.<p>
<dl compact><dt><b>Returns:</b></dt><dd>true if succeeded or false if database does not support transactions </dd></dl>
<p>
Reimplemented from <a class="el" href="classADODB__odbc.html#a4e7217890ef34c1965f7c3c325f7b96">ADODB_odbc</a>.
<p>
Definition at line <a class="el" href="adodb-vfp_8inc_8php-source.html#l00047">47</a> of file <a class="el" href="adodb-vfp_8inc_8php-source.html">adodb-vfp.inc.php</a>. </td>
</tr>
</table>
<a class="anchor" name="727e7bfb0f7f07bdc6fb4e9314357265"></a><!-- doxytag: member="ADODB_vfp::qstr" ref="727e7bfb0f7f07bdc6fb4e9314357265" args="($s, $nofixquotes=false)" --><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_vfp::qstr </td>
<td class="md" valign="top">( </td>
<td class="md" nowrap valign="top">$ </td>
<td class="mdname" nowrap> <em>s</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>nofixquotes</em> = <code>false</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>
Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes. An example is $db->qstr("Don't bother",magic_quotes_runtime());<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>s</em> </td><td>the string to quote </td></tr>
<tr><td valign="top"></td><td valign="top"><em>[magic_quotes]</em> </td><td>if $s is GET/POST var, set to get_magic_quotes_gpc(). This undoes the stupidity of magic quotes for GPC.</td></tr>
</table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>quoted string to be sent back to database </dd></dl>
<p>
Reimplemented from <a class="el" href="classADOConnection.html#980a29090390cdbbc2789d429642a2a8">ADOConnection</a>.
<p>
Definition at line <a class="el" href="adodb-vfp_8inc_8php-source.html#l00050">50</a> of file <a class="el" href="adodb-vfp_8inc_8php-source.html">adodb-vfp.inc.php</a>. </td>
</tr>
</table>
<a class="anchor" name="4aa918468ea5ad53609f457f627f7954"></a><!-- doxytag: member="ADODB_vfp::SelectLimit" ref="4aa918468ea5ad53609f457f627f7954" 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_vfp::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="classADOConnection.html#74acaf0a2c272abbad1e20b2efa0c7a4">ADOConnection</a>.
<p>
Definition at line <a class="el" href="adodb-vfp_8inc_8php-source.html#l00058">58</a> of file <a class="el" href="adodb-vfp_8inc_8php-source.html">adodb-vfp.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-vfp_8inc_8php-source.html">adodb-vfp.inc.php</a></ul>
<?php
include_once '../doc-typo3-funcs.php';
get_footer();
?>