<?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-sapdb.inc.php Source File",
"datetime" => "Sat Dec 2 19:22:26 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-sapdb.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. </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"> SAPDB data driver. Requires ODBC.</span>
<a name="l00012"></a>00012 <span class="comment"></span>
<a name="l00013"></a>00013 <span class="comment">*/</span>
<a name="l00014"></a>00014
<a name="l00015"></a>00015 <span class="comment">// security - hide paths</span>
<a name="l00016"></a>00016 <span class="keywordflow">if</span> (!defined('ADODB_DIR')) die();
<a name="l00017"></a>00017
<a name="l00018"></a>00018 <span class="keywordflow">if</span> (!defined('_ADODB_ODBC_LAYER')) {
<a name="l00019"></a>00019 include(ADODB_DIR.<span class="stringliteral">"/drivers/adodb-odbc.inc.php"</span>);
<a name="l00020"></a>00020 }
<a name="l00021"></a>00021 <span class="keywordflow">if</span> (!defined('<a class="code" href="classADODB__SAPDB.html">ADODB_SAPDB</a>')){
<a name="l00022"></a>00022 define('<a class="code" href="classADODB__SAPDB.html">ADODB_SAPDB</a>',1);
<a name="l00023"></a>00023
<a name="l00024"></a><a class="code" href="classADODB__SAPDB.html">00024</a> <span class="keyword">class </span><a class="code" href="classADODB__SAPDB.html">ADODB_SAPDB</a> <span class="keyword">extends</span> <a class="code" href="classADODB__odbc.html">ADODB_odbc</a> {
<a name="l00025"></a><a class="code" href="classADODB__SAPDB.html#3329fcc03bba47dfdd672747b4295ad3">00025</a> var <a class="code" href="classADODB__SAPDB.html#3329fcc03bba47dfdd672747b4295ad3">$databaseType</a> = <span class="stringliteral">"sapdb"</span>;
<a name="l00026"></a><a class="code" href="classADODB__SAPDB.html#563878c5791582f04c0c452c2b50d941">00026</a> var <a class="code" href="classADODB__SAPDB.html#563878c5791582f04c0c452c2b50d941">$concat_operator</a> = '||';
<a name="l00027"></a><a class="code" href="classADODB__SAPDB.html#b48c64db2658a0df9ff4062267b2d5cd">00027</a> var <a class="code" href="classADODB__SAPDB.html#b48c64db2658a0df9ff4062267b2d5cd">$sysDate</a> = 'DATE';
<a name="l00028"></a><a class="code" href="classADODB__SAPDB.html#4a6757d5c5e84de466450cebcc90579b">00028</a> var <a class="code" href="classADODB__SAPDB.html#4a6757d5c5e84de466450cebcc90579b">$sysTimeStamp</a> = 'TIMESTAMP';
<a name="l00029"></a><a class="code" href="classADODB__SAPDB.html#dad18268760de20a6865f9b37e4bf065">00029</a> var <a class="code" href="classADODB__SAPDB.html#dad18268760de20a6865f9b37e4bf065">$fmtDate</a> = <span class="stringliteral">"'Y-m-d'"</span>;
<a name="l00030"></a><a class="code" href="classADODB__SAPDB.html#35777646e5e4273e8c35ee06f55d5898">00030</a> var <a class="code" href="classADODB__SAPDB.html#35777646e5e4273e8c35ee06f55d5898">$fmtTimeStamp</a> = <span class="stringliteral">"'Y-m-d H:i:s'"</span>;
<a name="l00031"></a><a class="code" href="classADODB__SAPDB.html#571b37a9a0537a72a960e3da49532722">00031</a> var <a class="code" href="classADODB__SAPDB.html#571b37a9a0537a72a960e3da49532722">$hasInsertId</a> = <span class="keyword">true</span>;
<a name="l00032"></a><a class="code" href="classADODB__SAPDB.html#df60e87c294d07b91aa417dd19969c8c">00032</a> var <a class="code" href="classADODB__SAPDB.html#df60e87c294d07b91aa417dd19969c8c">$_bindInputArray</a> = <span class="keyword">true</span>;
<a name="l00033"></a>00033
<a name="l00034"></a><a class="code" href="classADODB__SAPDB.html#2c4b6d8c5a41aff6077fd5253b550d8c">00034</a> function <a class="code" href="classADODB__SAPDB.html#2c4b6d8c5a41aff6077fd5253b550d8c">ADODB_SAPDB</a>()
<a name="l00035"></a>00035 {
<a name="l00036"></a>00036 <span class="comment">//if (strncmp(PHP_OS,'WIN',3) === 0) $this->curmode = SQL_CUR_USE_ODBC;</span>
<a name="l00037"></a>00037 $this-><a class="code" href="classADODB__odbc.html#20d0ce3eb3d0ea050a8da318aa2b7460">ADODB_odbc</a>();
<a name="l00038"></a>00038 }
<a name="l00039"></a>00039
<a name="l00040"></a><a class="code" href="classADODB__SAPDB.html#aa64c0f4a58ea05adafaf36046b2b389">00040</a> function <a class="code" href="classADODB__SAPDB.html#aa64c0f4a58ea05adafaf36046b2b389">ServerInfo</a>()
<a name="l00041"></a>00041 {
<a name="l00042"></a>00042 $info = <a class="code" href="classADODB__odbc.html#3539c35663279e7493609d96c941933a">ADODB_odbc::ServerInfo</a>();
<a name="l00043"></a>00043 <span class="keywordflow">if</span> (!$info['version'] && preg_match('/([0-9.]+)/',$info['description'],$matches)) {
<a name="l00044"></a>00044 $info['version'] = $matches[1];
<a name="l00045"></a>00045 }
<a name="l00046"></a>00046 <span class="keywordflow">return</span> $info;
<a name="l00047"></a>00047 }
<a name="l00048"></a>00048
<a name="l00049"></a><a class="code" href="classADODB__SAPDB.html#a8dabc404f3bc6090b96b7d1e13f0600">00049</a> function <a class="code" href="classADODB__SAPDB.html#a8dabc404f3bc6090b96b7d1e13f0600">MetaPrimaryKeys</a>($table)
<a name="l00050"></a>00050 {
<a name="l00051"></a>00051 $table = $this-><a class="code" href="classADOConnection.html#14c6e2880b61b6043a08d4ce62497fd7">Quote</a>(strtoupper($table));
<a name="l00052"></a>00052
<a name="l00053"></a>00053 <span class="keywordflow">return</span> $this-><a class="code" href="classADOConnection.html#b479186e3e804f7c03438dc619d42a04">GetCol</a>(<span class="stringliteral">"SELECT columnname FROM COLUMNS WHERE tablename=$table AND mode='KEY' ORDER BY pos"</span>);
<a name="l00054"></a>00054 }
<a name="l00055"></a>00055
<a name="l00056"></a><a class="code" href="classADODB__SAPDB.html#e5a408ff77646df901a88d537f55fc28">00056</a> function &<a class="code" href="classADODB__SAPDB.html#e5a408ff77646df901a88d537f55fc28">MetaIndexes</a> ($table, $primary = FALSE)
<a name="l00057"></a>00057 {
<a name="l00058"></a>00058 $table = $this-><a class="code" href="classADOConnection.html#14c6e2880b61b6043a08d4ce62497fd7">Quote</a>(strtoupper($table));
<a name="l00059"></a>00059
<a name="l00060"></a>00060 $sql = <span class="stringliteral">"SELECT INDEXNAME,TYPE,COLUMNNAME FROM INDEXCOLUMNS "</span>.
<a name="l00061"></a>00061 <span class="stringliteral">" WHERE TABLENAME=$table"</span>.
<a name="l00062"></a>00062 <span class="stringliteral">" ORDER BY INDEXNAME,COLUMNNO"</span>;
<a name="l00063"></a>00063
<a name="l00064"></a>00064 global $ADODB_FETCH_MODE;
<a name="l00065"></a>00065 $save = $ADODB_FETCH_MODE;
<a name="l00066"></a>00066 $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
<a name="l00067"></a>00067 <span class="keywordflow">if</span> ($this->fetchMode !== FALSE) {
<a name="l00068"></a>00068 $savem = $this-><a class="code" href="classADOConnection.html#c4d88495c37f94d56001745af5b46372">SetFetchMode</a>(FALSE);
<a name="l00069"></a>00069 }
<a name="l00070"></a>00070
<a name="l00071"></a>00071 $rs = $this-><a class="code" href="classADOConnection.html#ab584eb160768657bc4113ff4e41d40c">Execute</a>($sql);
<a name="l00072"></a>00072 <span class="keywordflow">if</span> (isset($savem)) {
<a name="l00073"></a>00073 $this-><a class="code" href="classADOConnection.html#c4d88495c37f94d56001745af5b46372">SetFetchMode</a>($savem);
<a name="l00074"></a>00074 }
<a name="l00075"></a>00075 $ADODB_FETCH_MODE = $save;
<a name="l00076"></a>00076
<a name="l00077"></a>00077 <span class="keywordflow">if</span> (!is_object($rs)) {
<a name="l00078"></a>00078 <span class="keywordflow">return</span> FALSE;
<a name="l00079"></a>00079 }
<a name="l00080"></a>00080
<a name="l00081"></a>00081 $indexes = array();
<a name="l00082"></a>00082 <span class="keywordflow">while</span> ($row = $rs->FetchRow()) {
<a name="l00083"></a>00083 $indexes[$row[0]]['unique'] = $row[1] == 'UNIQUE';
<a name="l00084"></a>00084 $indexes[$row[0]]['columns'][] = $row[2];
<a name="l00085"></a>00085 }
<a name="l00086"></a>00086 <span class="keywordflow">if</span> ($primary) {
<a name="l00087"></a>00087 $indexes['SYSPRIMARYKEYINDEX'] = array(
<a name="l00088"></a>00088 'unique' => True, <span class="comment">// by definition</span>
<a name="l00089"></a>00089 'columns' => $this-><a class="code" href="classADOConnection.html#b479186e3e804f7c03438dc619d42a04">GetCol</a>(<span class="stringliteral">"SELECT columnname FROM COLUMNS WHERE tablename=$table AND mode='KEY' ORDER BY pos"</span>),
<a name="l00090"></a>00090 );
<a name="l00091"></a>00091 }
<a name="l00092"></a>00092 <span class="keywordflow">return</span> $indexes;
<a name="l00093"></a>00093 }
<a name="l00094"></a>00094
<a name="l00095"></a><a class="code" href="classADODB__SAPDB.html#ac3627d90238061d49171a8a79f1f37e">00095</a> function &<a class="code" href="classADODB__SAPDB.html#ac3627d90238061d49171a8a79f1f37e">MetaColumns</a> ($table)
<a name="l00096"></a>00096 {
<a name="l00097"></a>00097 global $ADODB_FETCH_MODE;
<a name="l00098"></a>00098 $save = $ADODB_FETCH_MODE;
<a name="l00099"></a>00099 $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
<a name="l00100"></a>00100 <span class="keywordflow">if</span> ($this->fetchMode !== FALSE) {
<a name="l00101"></a>00101 $savem = $this-><a class="code" href="classADOConnection.html#c4d88495c37f94d56001745af5b46372">SetFetchMode</a>(FALSE);
<a name="l00102"></a>00102 }
<a name="l00103"></a>00103 $table = $this-><a class="code" href="classADOConnection.html#14c6e2880b61b6043a08d4ce62497fd7">Quote</a>(strtoupper($table));
<a name="l00104"></a>00104
<a name="l00105"></a>00105 $retarr = array();
<a name="l00106"></a>00106 foreach($this-><a class="code" href="classADOConnection.html#ca9d53d8763b869d484c371eff16945e">GetAll</a>(<span class="stringliteral">"SELECT COLUMNNAME,DATATYPE,LEN,DEC,NULLABLE,MODE,\"DEFAULT\",CASE WHEN \"DEFAULT\" IS NULL THEN 0 ELSE 1 END AS HAS_DEFAULT FROM COLUMNS WHERE tablename=$table ORDER BY pos"</span>) as $column)
<a name="l00107"></a>00107 {
<a name="l00108"></a>00108 $fld = <span class="keyword">new</span> <a class="code" href="classADOFieldObject.html">ADOFieldObject</a>();
<a name="l00109"></a>00109 $fld->name = $column[0];
<a name="l00110"></a>00110 $fld->type = $column[1];
<a name="l00111"></a>00111 $fld->max_length = $fld->type == 'LONG' ? 2147483647 : $column[2];
<a name="l00112"></a>00112 $fld->scale = $column[3];
<a name="l00113"></a>00113 $fld->not_null = $column[4] == 'NO';
<a name="l00114"></a>00114 $fld->primary_key = $column[5] == 'KEY';
<a name="l00115"></a>00115 <span class="keywordflow">if</span> ($fld->has_default = $column[7]) {
<a name="l00116"></a>00116 <span class="keywordflow">if</span> ($fld->primary_key && $column[6] == 'DEFAULT SERIAL (1)') {
<a name="l00117"></a>00117 $fld->auto_increment = <span class="keyword">true</span>;
<a name="l00118"></a>00118 $fld->has_default = <span class="keyword">false</span>;
<a name="l00119"></a>00119 } <span class="keywordflow">else</span> {
<a name="l00120"></a>00120 $fld->default_value = $column[6];
<a name="l00121"></a>00121 <span class="keywordflow">switch</span>($fld->type) {
<a name="l00122"></a>00122 <span class="keywordflow">case</span> 'VARCHAR':
<a name="l00123"></a>00123 <span class="keywordflow">case</span> 'CHARACTER':
<a name="l00124"></a>00124 <span class="keywordflow">case</span> 'LONG':
<a name="l00125"></a>00125 $fld->default_value = $column[6];
<a name="l00126"></a>00126 <span class="keywordflow">break</span>;
<a name="l00127"></a>00127 <span class="keywordflow">default</span>:
<a name="l00128"></a>00128 $fld->default_value = trim($column[6]);
<a name="l00129"></a>00129 <span class="keywordflow">break</span>;
<a name="l00130"></a>00130 }
<a name="l00131"></a>00131 }
<a name="l00132"></a>00132 }
<a name="l00133"></a>00133 $retarr[$fld->name] = $fld;
<a name="l00134"></a>00134 }
<a name="l00135"></a>00135 <span class="keywordflow">if</span> (isset($savem)) {
<a name="l00136"></a>00136 $this-><a class="code" href="classADOConnection.html#c4d88495c37f94d56001745af5b46372">SetFetchMode</a>($savem);
<a name="l00137"></a>00137 }
<a name="l00138"></a>00138 $ADODB_FETCH_MODE = $save;
<a name="l00139"></a>00139
<a name="l00140"></a>00140 <span class="keywordflow">return</span> $retarr;
<a name="l00141"></a>00141 }
<a name="l00142"></a>00142
<a name="l00143"></a><a class="code" href="classADODB__SAPDB.html#a860b9ee3a37f6007ebd3917e0691dd7">00143</a> function <a class="code" href="classADODB__SAPDB.html#a860b9ee3a37f6007ebd3917e0691dd7">MetaColumnNames</a>($table)
<a name="l00144"></a>00144 {
<a name="l00145"></a>00145 $table = $this-><a class="code" href="classADOConnection.html#14c6e2880b61b6043a08d4ce62497fd7">Quote</a>(strtoupper($table));
<a name="l00146"></a>00146
<a name="l00147"></a>00147 <span class="keywordflow">return</span> $this-><a class="code" href="classADOConnection.html#b479186e3e804f7c03438dc619d42a04">GetCol</a>(<span class="stringliteral">"SELECT columnname FROM COLUMNS WHERE tablename=$table ORDER BY pos"</span>);
<a name="l00148"></a>00148 }
<a name="l00149"></a>00149
<a name="l00150"></a>00150 <span class="comment">// unlike it seems, this depends on the db-session and works in a multiuser environment</span>
<a name="l00151"></a><a class="code" href="classADODB__SAPDB.html#c4ebd3993f84f9713ee6f2618c50fee5">00151</a> function <a class="code" href="classADODB__SAPDB.html#c4ebd3993f84f9713ee6f2618c50fee5">_insertid</a>($table,$column)
<a name="l00152"></a>00152 {
<a name="l00153"></a>00153 <span class="keywordflow">return</span> empty($table) ? False : $this-><a class="code" href="classADOConnection.html#cc46074c4b2354d07427f8887f92b994">GetOne</a>(<span class="stringliteral">"SELECT $table.CURRVAL FROM DUAL"</span>);
<a name="l00154"></a>00154 }
<a name="l00155"></a>00155
<a name="l00156"></a>00156 <span class="comment">/*</span>
<a name="l00157"></a>00157 <span class="comment"> SelectLimit implementation problems:</span>
<a name="l00158"></a>00158 <span class="comment"> </span>
<a name="l00159"></a>00159 <span class="comment"> The following will return random 10 rows as order by performed after "WHERE rowno<10"</span>
<a name="l00160"></a>00160 <span class="comment"> which is not ideal...</span>
<a name="l00161"></a>00161 <span class="comment"> </span>
<a name="l00162"></a>00162 <span class="comment"> select * from table where rowno < 10 order by 1</span>
<a name="l00163"></a>00163 <span class="comment"> </span>
<a name="l00164"></a>00164 <span class="comment"> This means that we have to use the adoconnection base class SelectLimit when</span>
<a name="l00165"></a>00165 <span class="comment"> there is an "order by".</span>
<a name="l00166"></a>00166 <span class="comment"> </span>
<a name="l00167"></a>00167 <span class="comment"> See http://listserv.sap.com/pipermail/sapdb.general/2002-January/010405.html</span>
<a name="l00168"></a>00168 <span class="comment"> */</span>
<a name="l00169"></a>00169
<a name="l00170"></a>00170 };
<a name="l00171"></a>00171
<a name="l00172"></a>00172
<a name="l00173"></a><a class="code" href="classADORecordSet__sapdb.html">00173</a> <span class="keyword">class </span><a class="code" href="classADORecordSet__sapdb.html">ADORecordSet_sapdb</a> <span class="keyword">extends</span> <a class="code" href="classADORecordSet__odbc.html">ADORecordSet_odbc</a> {
<a name="l00174"></a>00174
<a name="l00175"></a><a class="code" href="classADORecordSet__sapdb.html#ecbb82c3cd48fc51b71ca1322f19385b">00175</a> var <a class="code" href="classADORecordSet__sapdb.html#ecbb82c3cd48fc51b71ca1322f19385b">$databaseType</a> = <span class="stringliteral">"sapdb"</span>;
<a name="l00176"></a>00176
<a name="l00177"></a><a class="code" href="classADORecordSet__sapdb.html#92449660db107277de32e0d0ea1fcf02">00177</a> function <a class="code" href="classADORecordSet__sapdb.html#92449660db107277de32e0d0ea1fcf02">ADORecordSet_sapdb</a>($id,$mode=<span class="keyword">false</span>)
<a name="l00178"></a>00178 {
<a name="l00179"></a>00179 $this-><a class="code" href="classADORecordSet__odbc.html#1a3b48ac4fadfb73d1f0a876d76211ca">ADORecordSet_odbc</a>($id,$mode);
<a name="l00180"></a>00180 }
<a name="l00181"></a>00181 }
<a name="l00182"></a>00182
<a name="l00183"></a>00183 } <span class="comment">//define</span>
<a name="l00184"></a>00184 ?>
</pre></div><?php
include_once '../doc-typo3-funcs.php';
get_footer();
?>