<?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 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 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="nav"> <a class="el" href="dir_c8daf1ad746050abf985cc546c89e248.html">typo3_src-4.0.1</a> » <a class="el" href="dir_18071ae4545d8b3e0364d30c0659c74a.html">typo3</a> » <a class="el" href="dir_57bf1ed8249c1fd5b014486d01bcb27a.html">sysext</a> » <a class="el" href="dir_e81b1679233d44b74aed493d6fe8e943.html">adodb</a> » <a class="el" href="dir_1f526b87ad011e46f671ba6e798564e1.html">adodb</a> » <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 <?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-><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 &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->_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->_has_stupid_odbc_fetch_api_change = $this->_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 = &$rs->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 < sizeof($arr); $i++) {</span> <a name="l00068"></a>00068 <span class="comment"> if ($arr[$i][2] && $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-><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 ?> </pre></div><?php include_once '../doc-typo3-funcs.php'; get_footer(); ?>