<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>RE: [python-sybase] Sybase stored procs question</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Mike,</FONT>
</P>
<P><FONT SIZE=2>Firstly may I point you to the documentation?:</FONT>
</P>
<P><FONT SIZE=2><A HREF="http://www.object-craft.com.au/projects/sybase/sybase/" TARGET="_blank">http://www.object-craft.com.au/projects/sybase/sybase/</A></FONT>
</P>
<P><FONT SIZE=2>It should answer most of your questions. Secondly, on the cursor object is a method named nextset() this is what you want. The documentation contains a full description of what this method does.</FONT></P>
<P><FONT SIZE=2>Grant</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: python-sybase-bounces@www.object-craft.com.au</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:python-sybase-bounces@www.object-craft.com.au">mailto:python-sybase-bounces@www.object-craft.com.au</A>]On Behalf Of mike</FONT>
<BR><FONT SIZE=2>Sent: Thursday, April 06, 2006 7:21 PM</FONT>
<BR><FONT SIZE=2>To: Python Sybase</FONT>
<BR><FONT SIZE=2>Subject: [python-sybase] Sybase stored procs question</FONT>
</P>
<BR>
<P><FONT SIZE=2>hi</FONT>
</P>
<P><FONT SIZE=2>I have a Sybase stored proc that was coded such that it returns a</FONT>
<BR><FONT SIZE=2>number of "select" statements to the caller.</FONT>
</P>
<P><FONT SIZE=2>eg</FONT>
<BR><FONT SIZE=2>select 'Begin Processing...'</FONT>
<BR><FONT SIZE=2>...</FONT>
<BR><FONT SIZE=2>select 'Transaction finished'</FONT>
</P>
<BR>
<P><FONT SIZE=2>I have tried to call this procedures using execute or callproc</FONT>
<BR><FONT SIZE=2>methods, but was only able to return the first result ie 'Begin</FONT>
<BR><FONT SIZE=2>Processing' , using fetchall. How can i catch all "select" outputs..</FONT>
<BR><FONT SIZE=2>thanks</FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>Python-sybase mailing list</FONT>
<BR><FONT SIZE=2>Python-sybase@www.object-craft.com.au</FONT>
<BR><FONT SIZE=2><A HREF="https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase" TARGET="_blank">https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase</A></FONT>
</P>
</BODY>
<!--[object_id=#infocomp.com#]--><P><FONT face=Arial color=#808080 size=1>Important notice: This message is intended for the individual(s) and entity(s) addressed. The information contained in this transmission and any attached, may be confidential and may also be the subject of legal privilege, public interest immunity or legal professional privilege. Any review, retransmission, dissemination or other use of, taking of any action in reliance upon this information by person or entities other than the recipient is prohibited and requires authorization from the sender. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person) you may not copy or deliver this message to anyone. In such cases you should destroy this message and kindly notify the sender by reply email. </FONT></P>
<P><FONT face=Arial color=#808080 size=1>WARNING: Although Infocomp has taken reasonable precautions so that no viruses are present in this e-mail, the company cannot accept responsibility for any loss or damage arising from the use of e-mail attachments.</FONT></P></HTML>