Python DB API - commit() v. execute("commit transaction")?

[Skip Montanaro]

Well, you can't do that, because you can't iterate over an execute().
You would do:

    cur.execute("SELECT ...")
    for row1 in cur.fetchall():
        cur.execute("SELECT ...")
        for row2 in cur.fetchall():
            ....


Whoops, yeah. I think one of the adapters at my disposal at work (maybe one
layered on top of pyodbc) allows me to do that. I get confused. Never just
type (pseudo) code into an email message...

Skip