Why can't use cursor.nextset() in adodbapi package?
timr at probo.com
Tue Jan 25 09:23:39 CET 2005
nightmarch <nightmarch at gmail.com> wrote:
>Thank you Dennis!
>You mean I should execute many select statement like this " rec =
>crsr.fetchall() " ?
No, you misunderstand. nextset() is used when you issue several SELECT
statements in a single request. The first fetchall() gets the results of
the first SELECT statement. To get the next one, you use nextset().
Your example only had one SELECT:
>> > >>> sql = "select * from wjtmp"
>> > >>> crsr.execute(sql)
>> > >>> rec = crsr.fetchone()
>> > >>> crsr.nextset()
If you are only issuing one SELECT, like most applications, then nextset()
serves no purpose. If you did something like this:
sql = "select * from wjtmp; select count(*) from wjtmp;"
That's when you need nextset(). Personally, I've never used it.
- Tim Roberts, timr at probo.com
Providenza & Boekelheide, Inc.
More information about the Python-list