----- Forwarded Message ----
From: srinivasan srinivas <[email protected]>
To: [email protected]
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: "[email protected]" <[email protected]>
To: srinivasan srinivas <[email protected]>
Cc: [email protected]
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 - [email protected] - 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/
--
http://mail.python.org/mailman/listinfo/python-list

Reply via email to