<?php
  include_once '../doc-typo3-funcs.php';
  $doxygen_vars = array(	"title" => "TYPO3 4.0.1: typo3_src-4.0.1/typo3/sysext/adodb/adodb/drivers/adodb-access.inc.php Source File",
				"datetime" => "Sat Dec 2 19:22: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><a href="classes.html"><span>Classes</span></a></li>
    <li id="current"><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="nav">
<a class="el" href="dir_c8daf1ad746050abf985cc546c89e248.html">typo3_src-4.0.1</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_18071ae4545d8b3e0364d30c0659c74a.html">typo3</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_57bf1ed8249c1fd5b014486d01bcb27a.html">sysext</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_e81b1679233d44b74aed493d6fe8e943.html">adodb</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_1f526b87ad011e46f671ba6e798564e1.html">adodb</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_1e0b3ded0d6f913dc09ca6aa6ebd4980.html">drivers</a></div>
<h1>adodb-access.inc.php</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00002"></a>00002 <span class="comment">/* </span>
<a name="l00003"></a>00003 <span class="comment">V4.90 8 June 2006  (c) 2000-2006 John Lim (jlim#natsoft.com.my). All rights reserved.</span>
<a name="l00004"></a>00004 <span class="comment">  Released under both BSD license and Lesser GPL library license. </span>
<a name="l00005"></a>00005 <span class="comment">  Whenever there is any discrepancy between the two licenses, </span>
<a name="l00006"></a>00006 <span class="comment">  the BSD license will take precedence. See License.txt. </span>
<a name="l00007"></a>00007 <span class="comment">  Set tabs to 4 for best viewing.</span>
<a name="l00008"></a>00008 <span class="comment">  </span>
<a name="l00009"></a>00009 <span class="comment">  Latest version is available at http://adodb.sourceforge.net</span>
<a name="l00010"></a>00010 <span class="comment">  </span>
<a name="l00011"></a>00011 <span class="comment">  Microsoft Access data driver. Requires ODBC. Works only on MS Windows.</span>
<a name="l00012"></a>00012 <span class="comment">*/</span>
<a name="l00013"></a>00013 <span class="keywordflow">if</span> (!defined('_ADODB_ODBC_LAYER')) {
<a name="l00014"></a>00014         <span class="keywordflow">if</span> (!defined('ADODB_DIR')) die();
<a name="l00015"></a>00015         
<a name="l00016"></a>00016         include(ADODB_DIR.<span class="stringliteral">"/drivers/adodb-odbc.inc.php"</span>);
<a name="l00017"></a>00017 }
<a name="l00018"></a>00018  <span class="keywordflow">if</span> (!defined('_ADODB_ACCESS')) {
<a name="l00019"></a>00019         define('_ADODB_ACCESS',1);
<a name="l00020"></a>00020 
<a name="l00021"></a><a class="code" href="classADODB__access.html">00021</a> <span class="keyword">class  </span><a class="code" href="classADODB__access.html">ADODB_access</a> <span class="keyword">extends</span> <a class="code" href="classADODB__odbc.html">ADODB_odbc</a> {        
<a name="l00022"></a><a class="code" href="classADODB__access.html#9c5354480923562b3ad598629a3dc5f7">00022</a>         var <a class="code" href="classADODB__access.html#9c5354480923562b3ad598629a3dc5f7">$databaseType</a> = 'access';
<a name="l00023"></a><a class="code" href="classADODB__access.html#3dc352597f5526693f7dc1d9a6e83394">00023</a>         var <a class="code" href="classADODB__access.html#3dc352597f5526693f7dc1d9a6e83394">$hasTop</a> = 'top';            <span class="comment">// support mssql SELECT TOP 10 * FROM TABLE</span>
<a name="l00024"></a><a class="code" href="classADODB__access.html#f3550d5edd529e22891fc0f09957a12a">00024</a>         var <a class="code" href="classADODB__access.html#f3550d5edd529e22891fc0f09957a12a">$fmtDate</a> = <span class="stringliteral">"#Y-m-d#"</span>;
<a name="l00025"></a><a class="code" href="classADODB__access.html#0b16bbfd5b231f43b86975658a325fe7">00025</a>         var <a class="code" href="classADODB__access.html#0b16bbfd5b231f43b86975658a325fe7">$fmtTimeStamp</a> = <span class="stringliteral">"#Y-m-d h:i:sA#"</span>; <span class="comment">// note not comma</span>
<a name="l00026"></a><a class="code" href="classADODB__access.html#b7523cccb322d5af80541b65dac3c852">00026</a>         var <a class="code" href="classADODB__access.html#b7523cccb322d5af80541b65dac3c852">$_bindInputArray</a> = <span class="keyword">false</span>; <span class="comment">// strangely enough, setting to true does not work reliably</span>
<a name="l00027"></a><a class="code" href="classADODB__access.html#71517fb000fd323fc9c5100d8d6c6b2e">00027</a>         var <a class="code" href="classADODB__access.html#71517fb000fd323fc9c5100d8d6c6b2e">$sysDate</a> = <span class="stringliteral">"FORMAT(NOW,'yyyy-mm-dd')"</span>;
<a name="l00028"></a><a class="code" href="classADODB__access.html#37748e1961563a39bf85868741fef276">00028</a>         var <a class="code" href="classADODB__access.html#37748e1961563a39bf85868741fef276">$sysTimeStamp</a> = 'NOW';
<a name="l00029"></a><a class="code" href="classADODB__access.html#1f14489b37f7ed0014d8a68596df01ba">00029</a>         var <a class="code" href="classADODB__access.html#1f14489b37f7ed0014d8a68596df01ba">$hasTransactions</a> = <span class="keyword">false</span>;
<a name="l00030"></a>00030         
<a name="l00031"></a><a class="code" href="classADODB__access.html#ee69049092b776b4ffab5f7e694dc583">00031</a>         function <a class="code" href="classADODB__access.html#ee69049092b776b4ffab5f7e694dc583">ADODB_access</a>()
<a name="l00032"></a>00032         {
<a name="l00033"></a>00033         global $ADODB_EXTENSION;
<a name="l00034"></a>00034         
<a name="l00035"></a>00035                 $ADODB_EXTENSION = <span class="keyword">false</span>;
<a name="l00036"></a>00036                 $this-&gt;<a class="code" href="classADODB__odbc.html#20d0ce3eb3d0ea050a8da318aa2b7460">ADODB_odbc</a>();
<a name="l00037"></a>00037         }
<a name="l00038"></a>00038         
<a name="l00039"></a><a class="code" href="classADODB__access.html#a80f8d293526f9696e2f5344d8b6f7ad">00039</a>         function <a class="code" href="classADODB__access.html#a80f8d293526f9696e2f5344d8b6f7ad">Time</a>()
<a name="l00040"></a>00040         {
<a name="l00041"></a>00041                 <span class="keywordflow">return</span> time();
<a name="l00042"></a>00042         }
<a name="l00043"></a>00043         
<a name="l00044"></a><a class="code" href="classADODB__access.html#5c7bc784683e230b6e293fd8b1edd587">00044</a>         function <a class="code" href="classADODB__access.html#5c7bc784683e230b6e293fd8b1edd587">BeginTrans</a>() { <span class="keywordflow">return</span> <span class="keyword">false</span>;}
<a name="l00045"></a>00045         
<a name="l00046"></a><a class="code" href="classADODB__access.html#8ff35ceaefe5d40f75b6641ed1a87041">00046</a>         function <a class="code" href="classADODB__access.html#8ff35ceaefe5d40f75b6641ed1a87041">IfNull</a>( $field, $ifNull ) 
<a name="l00047"></a>00047         {
<a name="l00048"></a>00048                 <span class="keywordflow">return</span> <span class="stringliteral">" IIF(IsNull($field), $ifNull, $field) "</span>; <span class="comment">// if Access</span>
<a name="l00049"></a>00049         }
<a name="l00050"></a>00050 <span class="comment">/*</span>
<a name="l00051"></a>00051 <span class="comment">        function &amp;MetaTables()</span>
<a name="l00052"></a>00052 <span class="comment">        {</span>
<a name="l00053"></a>00053 <span class="comment">        global $ADODB_FETCH_MODE;</span>
<a name="l00054"></a>00054 <span class="comment">        </span>
<a name="l00055"></a>00055 <span class="comment">                $savem = $ADODB_FETCH_MODE;</span>
<a name="l00056"></a>00056 <span class="comment">                $ADODB_FETCH_MODE = ADODB_FETCH_NUM;</span>
<a name="l00057"></a>00057 <span class="comment">                $qid = odbc_tables($this-&gt;_connectionID);</span>
<a name="l00058"></a>00058 <span class="comment">                $rs = new ADORecordSet_odbc($qid);</span>
<a name="l00059"></a>00059 <span class="comment">                $ADODB_FETCH_MODE = $savem;</span>
<a name="l00060"></a>00060 <span class="comment">                if (!$rs) return false;</span>
<a name="l00061"></a>00061 <span class="comment">                </span>
<a name="l00062"></a>00062 <span class="comment">                $rs-&gt;_has_stupid_odbc_fetch_api_change = $this-&gt;_has_stupid_odbc_fetch_api_change;</span>
<a name="l00063"></a>00063 <span class="comment">                </span>
<a name="l00064"></a>00064 <span class="comment">                $arr = &amp;$rs-&gt;GetArray();</span>
<a name="l00065"></a>00065 <span class="comment">                //print_pre($arr);</span>
<a name="l00066"></a>00066 <span class="comment">                $arr2 = array();</span>
<a name="l00067"></a>00067 <span class="comment">                for ($i=0; $i &lt; sizeof($arr); $i++) {</span>
<a name="l00068"></a>00068 <span class="comment">                        if ($arr[$i][2] &amp;&amp; $arr[$i][3] != 'SYSTEM TABLE')</span>
<a name="l00069"></a>00069 <span class="comment">                                $arr2[] = $arr[$i][2];</span>
<a name="l00070"></a>00070 <span class="comment">                }</span>
<a name="l00071"></a>00071 <span class="comment">                return $arr2;</span>
<a name="l00072"></a>00072 <span class="comment">        }*/</span>
<a name="l00073"></a>00073 }
<a name="l00074"></a>00074 
<a name="l00075"></a>00075  
<a name="l00076"></a><a class="code" href="classADORecordSet__access.html">00076</a> <span class="keyword">class  </span><a class="code" href="classADORecordSet__access.html">ADORecordSet_access</a> <span class="keyword">extends</span> <a class="code" href="classADORecordSet__odbc.html">ADORecordSet_odbc</a> {  
<a name="l00077"></a>00077         
<a name="l00078"></a><a class="code" href="classADORecordSet__access.html#de538d7b5ee402de83a0632428e894f6">00078</a>         var <a class="code" href="classADORecordSet__access.html#de538d7b5ee402de83a0632428e894f6">$databaseType</a> = <span class="stringliteral">"access"</span>;           
<a name="l00079"></a>00079         
<a name="l00080"></a><a class="code" href="classADORecordSet__access.html#4a4fc75d70b671bb8caaaef5bd54f8a3">00080</a>         function <a class="code" href="classADORecordSet__access.html#4a4fc75d70b671bb8caaaef5bd54f8a3">ADORecordSet_access</a>($id,$mode=<span class="keyword">false</span>)
<a name="l00081"></a>00081         {
<a name="l00082"></a>00082                 <span class="keywordflow">return</span> $this-&gt;<a class="code" href="classADORecordSet__odbc.html#1a3b48ac4fadfb73d1f0a876d76211ca">ADORecordSet_odbc</a>($id,$mode);
<a name="l00083"></a>00083         }
<a name="l00084"></a>00084 }<span class="comment">// class</span>
<a name="l00085"></a>00085 } 
<a name="l00086"></a>00086 ?&gt;
</pre></div><?php
  include_once '../doc-typo3-funcs.php';
  get_footer();
?>