ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> phpdoc
phpdoc
[PHP-DOC] cvs: phpdoc /en/reference/uodbc/functions odbc-next-result.xml
by Richard Quadling other posts by this author
Nov 24 2006 1:27AM messages near this date
[PHP-DOC] cvs: phpdoc /en/reference/var/functions var-export.xml | [PHP-DOC] cvs: phpdoc /en/reference/uodbc/functions odbc-next-result.xml
rquadling		Fri Nov 24 09:24:40 2006 UTC

  Modified files:              
    /phpdoc/en/reference/uodbc/functions	odbc-next-result.xml 
  Log:
  RQuadling : Undocumented feature
  
  
http://cvs.php.net/viewvc.cgi/phpdoc/en/reference/uodbc/functions/odbc-next-result.xml?r1=1.
3&r2=1.4&diff_format=u
Index: phpdoc/en/reference/uodbc/functions/odbc-next-result.xml
diff -u phpdoc/en/reference/uodbc/functions/odbc-next-result.xml:1.3 phpdoc/en/reference/uod
bc/functions/odbc-next-result.xml:1.4
--- phpdoc/en/reference/uodbc/functions/odbc-next-result.xml:1.3	Fri May  9 13:12:17 2003
+++ phpdoc/en/reference/uodbc/functions/odbc-next-result.xml	Fri Nov 24 09:24:40 2006
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="iso-8859-1"?> 
-<!-- $Revision: 1.3 $ --> 
+<!-- $Revision: 1.4 $ --> 
 <!-- splitted from ./en/functions/uodbc.xml, last change in rev 1.29 --> 
   <refentry id='function.odbc-next-result'> 
    <refnamediv> 
@@ -15,7 +15,83 @@
       <methodparam> <type>resource</type><parameter>result_id</parameter></methodparam>
      </methodsynopsis> 
     <para> 
-     &warn.undocumented.func;
+     <function> odbc_next_result</function> will return &true; if there are more result sets
+     available as well as allowing access to the next result set via 
+     <function> odbc_fetch_array</function>, <function>odbc_fetch_row</function>, 
+     <function> odbc_result</function>, etc.
+    </para> 
+    <para> 
+     This function will return &false; on error.
+    </para> 
+    <para> 
+     The argument is a valid result identifier returned by <function> odbc_exec</function>.
+    </para> 
+    <para> 
+     <example> 
+      <title> <function>odbc_next_result</function></title>
+      <programlisting role="php"> 
+<![CDATA[
+<?php
+$r_Connection = odbc_connect($dsn, $username, $password);
+
+$s_SQL = <<<END_SQL
+SELECT 'A'
+SELECT 'B'
+SELECT 'C'
+END_SQL;
+
+$r_Results = odbc_exec($r_Connection, $s_SQL);
+
+$a_Row1 = odbc_fetch_array($r_Results);
+$a_Row2 = odbc_fetch_array($r_Results);
+echo "Dump first result set";
+var_dump($a_Row1, $a_Row2);
+
+echo "Get second results set ";
+var_dump(odbc_next_result($r_Results));
+
+$a_Row1 = odbc_fetch_array($r_Results);
+$a_Row2 = odbc_fetch_array($r_Results);
+echo "Dump second result set ";
+var_dump($a_Row1, $a_Row2);
+
+echo "Get third results set ";
+var_dump(odbc_next_result($r_Results));
+
+$a_Row1 = odbc_fetch_array($r_Results);
+$a_Row2 = odbc_fetch_array($r_Results);
+echo "Dump third result set ";
+var_dump($a_Row1, $a_Row2);
+
+echo "Try for a fourth result set ";
+var_dump(odbc_next_result($r_Results));
+?> 
+]]> 
+      </programlisting> 
+      &example.outputs;
+      <screen> 
+<![CDATA[
+Dump first result set array(1) {
+  ["A"]=> 
+  string(1) "A"
+}
+bool(false)
+Get second results set bool(true)
+Dump second result set array(1) {
+  ["B"]=> 
+  string(1) "B"
+}
+bool(false)
+Get third results set bool(true)
+Dump third result set array(1) {
+  ["C"]=> 
+  string(1) "C"
+}
+bool(false)
+Try for a fourth result set bool(false)
+]]> 
+      </screen> 
+     </example> 
     </para> 
    </refsect1> 
   </refentry> 
Thread:
Richard Quadling
Richard Quadling

Privacy Policy | Email Opt-out | Feedback | Syndication
© 2004 ActiveState, a division of Sophos All rights reserved