Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:299
Return-Path: <thekid@thekid.de>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 33492 invoked from network); 26 Mar 2003 10:07:24 -0000
Received: from unknown (HELO moutng.kundenserver.de) (212.227.126.171)
  by pb1.pair.com with SMTP; 26 Mar 2003 10:07:24 -0000
Received: from [212.227.126.205] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 18y7oX-0008HR-00; Wed, 26 Mar 2003 11:07:21 +0100
Received: from [217.80.180.210] (helo=[217.80.180.210])
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 18y7oW-0005lm-00; Wed, 26 Mar 2003 11:07:20 +0100
To: Sander Roobol <sander@php.net>
Cc: internals@lists.php.net
In-Reply-To: <20030323172643.GA5726@lxr>
References: <1048347373.25691.472.camel@localhost>
	 <20030323104858.GA2424@lxr> <1048430223.25691.484.camel@localhost>
	 <20030323172643.GA5726@lxr>
Content-Type: multipart/mixed; boundary="=-wERTAY3Ksr94ZWF5EK5H"
Organization: 
Message-ID: <1048673235.25691.550.camel@localhost>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.1 
Date: 26 Mar 2003 11:07:15 +0100
Subject: Re: [PHP-DEV] Bug #20836
From: thekid@thekid.de (Timm Friebe)

--=-wERTAY3Ksr94ZWF5EK5H
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Sun, 2003-03-23 at 18:26, Sander Roobol wrote:
> On Sun, Mar 23, 2003 at 03:37:03PM +0100, Timm Friebe wrote:
> > On Sun, 2003-03-23 at 11:48, Sander Roobol wrote:
> > > If you supply a unified diff, I'll commit it. 
> > 
> > OK. Attached is a unified diff - the three new files which need to be
> > added can be found at:
> 
> I've applied your patch, but I didn't add those three files since they
> already exist. Your files seem to have some improvements, so I suggest
> you merge your changes into the current version. Please do so and send a
> new unified diff.

After looking into it:
* sybase-fetch-assoc.xml is OK the way it is
* Added some examples to sybase-set-message-handler.xml 
* Corrected the statement "will fail" to "will produce a warning"
  and added an example to sybase-unbuffered-query.xml

Unified diff is attached.

HTH: Timm

--=-wERTAY3Ksr94ZWF5EK5H
Content-Disposition: attachment; filename=sybase_docs.diff
Content-Type: text/x-patch; name=sybase_docs.diff; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Index: sybase-set-message-handler.xml
===================================================================
RCS file: /repository/phpdoc/en/reference/sybase/functions/sybase-set-message-handler.xml,v
retrieving revision 1.1
diff -u -r1.1 sybase-set-message-handler.xml
--- sybase-set-message-handler.xml	8 Feb 2003 00:57:14 -0000	1.1
+++ sybase-set-message-handler.xml	26 Mar 2003 10:59:32 -0000
@@ -26,6 +26,55 @@
     <para>
      &return.success;
     </para>
+	<example>
+	 <title><function>sybase_set_message_handler</function> callback function</title>
+	 <programlisting role="php">
+<![CDATA[
+<?php
+	function msg_handler($msgnumber, $severity, $state, $line, $text) {
+		var_dump($msgnumber, $severity, $state, $line, $text);
+	}
+	
+	sybase_set_message_handler('msg_handler');
+?>
+]]>
+	 </programlisting>
+	</example>
+	<example>
+	 <title><function>sybase_set_message_handler</function> callback to a class</title>
+	 <programlisting role="php">
+<![CDATA[
+<?php
+	class Sybase {
+		function handler($msgnumber, $severity, $state, $line, $text) {
+			var_dump($msgnumber, $severity, $state, $line, $text);
+		}
+	}
+	
+	$sybase= new Sybase();
+	sybase_set_message_handler(array($sybase, 'handler'));
+?>
+]]>
+	 </programlisting>
+	</example>
+	<example>
+	 <title><function>sybase_set_message_handler</function> unhandled messages</title>
+	 <programlisting role="php">
+<![CDATA[
+<?php
+	// Return FALSE from this function to indicate you can't handle
+	// this. The error is printed out as a warning, the way you're used
+	// to it if there is no handler installed.
+	function msg_handler($msgnumber, $severity, $state, $line, $text) {
+		if (257 == $msgnumber) return FALSE;
+		var_dump($msgnumber, $severity, $state, $line, $text);
+	}
+	
+	sybase_set_message_handler('msg_handler');
+?>
+]]>
+	 </programlisting>
+	</example>
    </refsect1>
   </refentry>
 
Index: sybase-unbuffered-query.xml
===================================================================
RCS file: /repository/phpdoc/en/reference/sybase/functions/sybase-unbuffered-query.xml,v
retrieving revision 1.1
diff -u -r1.1 sybase-unbuffered-query.xml
--- sybase-unbuffered-query.xml	8 Feb 2003 00:57:14 -0000	1.1
+++ sybase-unbuffered-query.xml	26 Mar 2003 10:59:32 -0000
@@ -36,13 +36,36 @@
      of rows if all result sets have been read. To Sybase, the number of rows 
      is not known and is therefore computed by the client implementation.
     </para>
-    <para> 
-      It is not possible to fire up another query directly after starting an
-      unbuffered query and only if all rows have been read or the 
-      remainding rows have been cancelled. This can be acheived by using
-      <function>sybase_free_result</function> on the return value of
-      <function>sybase_unbuffered_query</function>.
+    <note>
+     <para> If you do'nt read all of the resultsets prior to executing the next query,
+      PHP will raise a warning and cancel all of the pending results. To get rid of
+      this, use <function>sybase_free_result</function> which will cancel pending 
+      results of an unbuffered query.
+     </para>
+    </note>
+    <para> The optional <parameter>store_result</parameter> can be FALSE to indicate
+     the resultsets should'nt be fetched into memory, thus minimizing memory usage
+     which is particularily interesting with very large resultsets.
     </para>
+    <example>
+     <title><function>sybase_unbuffered_query</function></title>
+     <programlisting role="php">
+<![CDATA[
+<?php
+       $dbh= sybase_connect('SYBASE', '', '');
+       $q= sybase_unbuffered_query('select firstname, lastname from huge_table', $dbh, FALSE);
+       sybase_data_seek($q, 10000);
+       $i= 0;
+       while ($row= sybase_fetch_row($q)) {
+               echo $row[0].' '.$row[0];
+               if ($i++ > 40000) break;
+       }
+       sybase_free_result($q);
+       sybase_close($dbh);
+?>
+]]>
+     </programlisting>
+    </example>
    </refsect1>
   </refentry>
 

--=-wERTAY3Ksr94ZWF5EK5H--