nightmarch <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] Providenza & Boekelheide, Inc. -- http://mail.python.org/mailman/listinfo/python-list
