Fw: Query regarding Python sybase module

[srinivasan srinivas]

----- Forwarded Message ----
From: srinivasan srinivas <[email protected]>
To: (e-mail address removed)
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: "(e-mail address removed)" <[email protected]>
To: srinivasan srinivas <[email protected]>
Cc: (e-mail address removed)
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 - (e-mail address removed) - 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/