Thank you Dennis! You mean I should execute many select statement like this " rec = crsr.fetchall() " ? But the result is the same, still got the error like "... 'Current provider does not support returning multiple recordsets from a single execution.'..."
On Mon, 24 Jan 2005 17:00:39 GMT, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote: > On Mon, 24 Jan 2005 17:18:05 +0800, nightmarch <[EMAIL PROTECTED]> > declaimed the following in comp.lang.python: > > > >>> sql = "select * from wjtmp" > > >>> crsr.execute(sql) > > >>> rec = crsr.fetchone() > > >>> crsr.nextset() > > > com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', > > (0, 'ADODB.Recordset', 'Current provider does not support returning > > multiple recordsets from a single execution.', > > 'C:\\WINNT\\HELP\\ADO210.CHM', 0, -2146825037), None) > > > > > > > > > > Why? > > > > Could it be because you don't have multiple recordsets in crsr? > > You're executing a single select statement, retrieving the > /first/ record from the result, and then trying to get a totally > different result set. > > Maybe you want the next record in the record set you already > have? crsr.fetchnext()? > > > thanks > > -- > > ============================================================== < > > [EMAIL PROTECTED] | Wulfraed Dennis Lee Bieber KD6MOG < > > [EMAIL PROTECTED] | Bestiaria Support Staff < > > ============================================================== < > > Home Page: <http://www.dm.net/~wulfraed/> < > > Overflow Page: <http://wlfraed.home.netcom.com/> < > -- > http://mail.python.org/mailman/listinfo/python-list > -- http://mail.python.org/mailman/listinfo/python-list
