<?php
include_once '../doc-typo3-funcs.php';
$doxygen_vars = array( "title" => "TYPO3 4.0.1: ADODB_odbc_mssql Class Reference",
"datetime" => "Sat Dec 2 19:23:31 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_odbc_mssql Class Reference</h1><!-- doxytag: class="ADODB_odbc_mssql" --><!-- doxytag: inherits="ADODB_odbc" -->Inheritance diagram for ADODB_odbc_mssql:<p><center><img src="classADODB__odbc__mssql__inherit__graph.png" border="0" usemap="#ADODB__odbc__mssql__inherit__map" alt="Inheritance graph"></center>
<map name="ADODB__odbc__mssql__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_odbc_mssql:<p><center><img src="classADODB__odbc__mssql__coll__graph.png" border="0" usemap="#ADODB__odbc__mssql__coll__map" alt="Collaboration graph"></center>
<map name="ADODB__odbc__mssql__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__odbc__mssql-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="8b63f657ca7c79df749b0b3fb5dd2701"></a><!-- doxytag: member="ADODB_odbc_mssql::ADODB_odbc_mssql" ref="8b63f657ca7c79df749b0b3fb5dd2701" args="()" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#8b63f657ca7c79df749b0b3fb5dd2701">ADODB_odbc_mssql</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#812e0906ff6f43abf6b5904b4bbfef77">ServerInfo</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="8c5e6d92084dc96a1f87baa2c100471d"></a><!-- doxytag: member="ADODB_odbc_mssql::IfNull" ref="8c5e6d92084dc96a1f87baa2c100471d" args="($field, $ifNull)" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#8c5e6d92084dc96a1f87baa2c100471d">IfNull</a> ($field, $ifNull)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="6c1647f24ad595d89ff915c0916f325d"></a><!-- doxytag: member="ADODB_odbc_mssql::_insertid" ref="6c1647f24ad595d89ff915c0916f325d" args="()" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#6c1647f24ad595d89ff915c0916f325d">_insertid</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#00ee6cd0725feb5a2dae7f47e44ab12d">MetaForeignKeys</a> ($table, $owner=false, $upper=false)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">& </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#6b2c0801ac7fc438323e61437e99d2a4">MetaTables</a> ($ttype=false, $showSchema=false, $mask=false)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="fd99adba275d582e6fb7a160e3374d19"></a><!-- doxytag: member="ADODB_odbc_mssql::MetaColumns" ref="fd99adba275d582e6fb7a160e3374d19" args="($table)" -->
& </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#fd99adba275d582e6fb7a160e3374d19">MetaColumns</a> ($table)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="5b0ae80fb3684d3dc3013fe1b49c3821"></a><!-- doxytag: member="ADODB_odbc_mssql::_query" ref="5b0ae80fb3684d3dc3013fe1b49c3821" args="($sql, $inputarr)" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#5b0ae80fb3684d3dc3013fe1b49c3821">_query</a> ($sql, $inputarr)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="a2c598d98c6aecce3dc3ff4128c3c839"></a><!-- doxytag: member="ADODB_odbc_mssql::SetTransactionMode" ref="a2c598d98c6aecce3dc3ff4128c3c839" args="($transaction_mode)" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#a2c598d98c6aecce3dc3ff4128c3c839">SetTransactionMode</a> ($transaction_mode)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="d7a30b81a3669df7d13da5dcd263af93"></a><!-- doxytag: member="ADODB_odbc_mssql::MetaPrimaryKeys" ref="d7a30b81a3669df7d13da5dcd263af93" args="($table)" -->
& </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#d7a30b81a3669df7d13da5dcd263af93">MetaPrimaryKeys</a> ($table)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">& </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#7901a8779057461f19ca44f93223c450">SelectLimit</a> ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="8b67649e4b9f1c1c84535f6f8af33319"></a><!-- doxytag: member="ADODB_odbc_mssql::SQLDate" ref="8b67649e4b9f1c1c84535f6f8af33319" args="($fmt, $col=false)" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#8b67649e4b9f1c1c84535f6f8af33319">SQLDate</a> ($fmt, $col=false)</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="2f61ff250615264214ebb4bae632bc8a"></a><!-- doxytag: member="ADODB_odbc_mssql::$databaseType" ref="2f61ff250615264214ebb4bae632bc8a" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#2f61ff250615264214ebb4bae632bc8a">$databaseType</a> = 'odbc_mssql'</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="0506bcbb4ae651ddbb47c08cd031209c"></a><!-- doxytag: member="ADODB_odbc_mssql::$fmtDate" ref="0506bcbb4ae651ddbb47c08cd031209c" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#0506bcbb4ae651ddbb47c08cd031209c">$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="d45323eab824cb2b5ab381e8dc4134ce"></a><!-- doxytag: member="ADODB_odbc_mssql::$fmtTimeStamp" ref="d45323eab824cb2b5ab381e8dc4134ce" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#d45323eab824cb2b5ab381e8dc4134ce">$fmtTimeStamp</a> = "'Y-m-d H:i:s'"</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="18af06ff2ba225364e17874e456fa599"></a><!-- doxytag: member="ADODB_odbc_mssql::$_bindInputArray" ref="18af06ff2ba225364e17874e456fa599" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#18af06ff2ba225364e17874e456fa599">$_bindInputArray</a> = true</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="f059618854f156d03ee1326fb69ef284"></a><!-- doxytag: member="ADODB_odbc_mssql::$metaTablesSQL" ref="f059618854f156d03ee1326fb69ef284" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#f059618854f156d03ee1326fb69ef284">$metaTablesSQL</a> = "select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE'))"</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="fc2d74112bb63d9889021a82d7baa2f6"></a><!-- doxytag: member="ADODB_odbc_mssql::$metaColumnsSQL" ref="fc2d74112bb63d9889021a82d7baa2f6" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#fc2d74112bb63d9889021a82d7baa2f6">$metaColumnsSQL</a> = "select c.name,t.name,c.length from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s'"</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="5562406be268dedb574e6abd11d5a62d"></a><!-- doxytag: member="ADODB_odbc_mssql::$hasTop" ref="5562406be268dedb574e6abd11d5a62d" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#5562406be268dedb574e6abd11d5a62d">$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="9e836545d25d33e3c823d564a286083c"></a><!-- doxytag: member="ADODB_odbc_mssql::$sysDate" ref="9e836545d25d33e3c823d564a286083c" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#9e836545d25d33e3c823d564a286083c">$sysDate</a> = 'GetDate()'</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="b4f53fffd448ca1b95839bc8a471f6cf"></a><!-- doxytag: member="ADODB_odbc_mssql::$sysTimeStamp" ref="b4f53fffd448ca1b95839bc8a471f6cf" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#b4f53fffd448ca1b95839bc8a471f6cf">$sysTimeStamp</a> = 'GetDate()'</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="42940f88cd1b837036dbde6fe1dd20b2"></a><!-- doxytag: member="ADODB_odbc_mssql::$leftOuter" ref="42940f88cd1b837036dbde6fe1dd20b2" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#42940f88cd1b837036dbde6fe1dd20b2">$leftOuter</a> = '*='</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">indicates that all fields in order by must be unique <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="91a3045e32fff5eecc296896e9472956"></a><!-- doxytag: member="ADODB_odbc_mssql::$rightOuter" ref="91a3045e32fff5eecc296896e9472956" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#91a3045e32fff5eecc296896e9472956">$rightOuter</a> = '=*'</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">operator to use for left outer join in WHERE clause <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="8eb0462bdaac804dc0d719931edf0e27"></a><!-- doxytag: member="ADODB_odbc_mssql::$substr" ref="8eb0462bdaac804dc0d719931edf0e27" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#8eb0462bdaac804dc0d719931edf0e27">$substr</a> = 'substring'</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">default concat operator -- change to || for Oracle/Interbase <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="2ae1662f7d7d64b16bdf1262cc3164a2"></a><!-- doxytag: member="ADODB_odbc_mssql::$length" ref="2ae1662f7d7d64b16bdf1262cc3164a2" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#2ae1662f7d7d64b16bdf1262cc3164a2">$length</a> = 'len'</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">substring operator <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="a1ab0b3712e433c84758d367aa6809c7"></a><!-- doxytag: member="ADODB_odbc_mssql::$ansiOuter" ref="a1ab0b3712e433c84758d367aa6809c7" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#a1ab0b3712e433c84758d367aa6809c7">$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="e0f463232b7c2cb0ff6fd1066e49a2f2"></a><!-- doxytag: member="ADODB_odbc_mssql::$identitySQL" ref="e0f463232b7c2cb0ff6fd1066e49a2f2" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#e0f463232b7c2cb0ff6fd1066e49a2f2">$identitySQL</a> = 'select @@IDENTITY'</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="2b317502fb972054ccb34215ef6b1c98"></a><!-- doxytag: member="ADODB_odbc_mssql::$hasInsertID" ref="2b317502fb972054ccb34215ef6b1c98" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#2b317502fb972054ccb34215ef6b1c98">$hasInsertID</a> = true</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="3a574c642d6a5826f4bacfb1ae5763a0"></a><!-- doxytag: member="ADODB_odbc_mssql::$connectStmt" ref="3a574c642d6a5826f4bacfb1ae5763a0" args="" -->
</td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__odbc__mssql.html#3a574c642d6a5826f4bacfb1ae5763a0">$connectStmt</a> = 'SET CONCAT_NULL_YIELDS_NULL OFF'</td></tr>
</table>
<hr><a name="_details"></a><h2>Detailed Description</h2>
<p>
<p>
Definition at line <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html#l00023">23</a> of file <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html">adodb-odbc_mssql.inc.php</a>.<hr><h2>Member Function Documentation</h2>
<a class="anchor" name="00ee6cd0725feb5a2dae7f47e44ab12d"></a><!-- doxytag: member="ADODB_odbc_mssql::MetaForeignKeys" ref="00ee6cd0725feb5a2dae7f47e44ab12d" args="($table, $owner=false, $upper=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_odbc_mssql::MetaForeignKeys </td>
<td class="md" valign="top">( </td>
<td class="md" nowrap valign="top">$ </td>
<td class="mdname" nowrap> <em>table</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>owner</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>upper</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>
<dl compact><dt><b>Returns:</b></dt><dd>assoc array where keys are tables, and values are foreign keys </dd></dl>
<p>
Reimplemented from <a class="el" href="classADOConnection.html#6dd0710477159469f6caf4785af0bed9">ADOConnection</a>.
<p>
Definition at line <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html#l00079">79</a> of file <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html">adodb-odbc_mssql.inc.php</a>.
<p>
References <a class="el" href="adodb_8inc_8php-source.html#l01357">ADOConnection::GetArray()</a>, and <a class="el" href="adodb_8inc_8php-source.html#l02500">ADOConnection::qstr()</a>. </td>
</tr>
</table>
<a class="anchor" name="6b2c0801ac7fc438323e61437e99d2a4"></a><!-- doxytag: member="ADODB_odbc_mssql::MetaTables" ref="6b2c0801ac7fc438323e61437e99d2a4" args="($ttype=false, $showSchema=false, $mask=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_odbc_mssql::MetaTables </td>
<td class="md" valign="top">( </td>
<td class="md" nowrap valign="top">$ </td>
<td class="mdname" nowrap> <em>ttype</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>showSchema</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>mask</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>
<dl compact><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>ttype</em> </td><td>can either be 'VIEW' or 'TABLE' or false. If false, both views and tables are returned. "VIEW" returns only views "TABLE" returns only tables </td></tr>
<tr><td valign="top"></td><td valign="top"><em>showSchema</em> </td><td>returns the schema/user with the table name, eg. USER.TABLE </td></tr>
<tr><td valign="top"></td><td valign="top"><em>mask</em> </td><td>is the input mask - only supported by oci8 and postgresql</td></tr>
</table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>array of tables for current database. </dd></dl>
<p>
Reimplemented from <a class="el" href="classADOConnection.html#7d701359f2ebe1738ab4f77fbb7f6305">ADOConnection</a>.
<p>
Definition at line <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html#l00118">118</a> of file <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html">adodb-odbc_mssql.inc.php</a>.
<p>
References <a class="el" href="adodb_8inc_8php-source.html#l02134">ADOConnection::MetaTables()</a>, and <a class="el" href="adodb_8inc_8php-source.html#l02500">ADOConnection::qstr()</a>. </td>
</tr>
</table>
<a class="anchor" name="7901a8779057461f19ca44f93223c450"></a><!-- doxytag: member="ADODB_odbc_mssql::SelectLimit" ref="7901a8779057461f19ca44f93223c450" 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_odbc_mssql::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-odbc__mssql_8inc_8php-source.html#l00182">182</a> of file <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html">adodb-odbc_mssql.inc.php</a>.
<p>
References <a class="el" href="adodb_8inc_8php-source.html#l00792">ADOConnection::Execute()</a>, and <a class="el" href="adodb_8inc_8php-source.html#l01102">ADOConnection::SelectLimit()</a>. </td>
</tr>
</table>
<a class="anchor" name="812e0906ff6f43abf6b5904b4bbfef77"></a><!-- doxytag: member="ADODB_odbc_mssql::ServerInfo" ref="812e0906ff6f43abf6b5904b4bbfef77" 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_odbc_mssql::ServerInfo </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>
Get server version info...<p>
<dl compact><dt><b>Returns:</b></dt><dd>An array with 2 elements: $arr['string'] is the description string, and $arr[version] is the version (also a string). </dd></dl>
<p>
Reimplemented from <a class="el" href="classADODB__odbc.html#3539c35663279e7493609d96c941933a">ADODB_odbc</a>.
<p>
Definition at line <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html#l00050">50</a> of file <a class="el" href="adodb-odbc__mssql_8inc_8php-source.html">adodb-odbc_mssql.inc.php</a>.
<p>
References <a class="el" href="adodb_8inc_8php-source.html#l00350">ADOConnection::_findvers()</a>, and <a class="el" href="adodb_8inc_8php-source.html#l01413">ADOConnection::GetRow()</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-odbc__mssql_8inc_8php-source.html">adodb-odbc_mssql.inc.php</a></ul>
<?php
include_once '../doc-typo3-funcs.php';
get_footer();
?>