Fw: Query regarding Python sybase module

[srinivasan srinivas]

----- Forwarded Message ----
From: srinivasan srinivas <sri_annauni at yahoo.co.in>
To: skip at pobox.com
Sent: Tuesday, 24 March, 2009 7:42:35 PM
Subject: Re: Query regarding Python sybase module

NO. I tried with what u have mentioned in the previous update.
But it gave only one result set.

Thanks,
Srini



----- Original Message ----
From: "skip at pobox.com" <skip at pobox.com>
To: srinivasan srinivas <sri_annauni at yahoo.co.in>
Cc: python-list at python.org
Sent: Tuesday, 24 March, 2009 6:40:37 PM
Subject: Re: Query regarding Python sybase module

    Srini> Does Sybase Python driver module implement multiple result sets
    Srini> from a single command?

I've used it to get multiple result sets from stored procedures, so I guess
the answer would be "yes".  Something like this:

    >>> params = curs.callproc('stored_procedure', params)
    >>> while True:
    ...  rows = curs.fetchall()
    ...  print rows
    ...  if not curs.nextset():
    ...    break

-- 
Skip Montanaro - skip at pobox.com - http://www.smontanaro.net/



      Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/



      Check out the all-new Messenger 9.0! Go to http://in.messenger.yahoo.com/