[DB-SIG] Reuse of DB-API 2.0 cursors for multiple queries?

(Reposted to DB-SIG from clp) This week, I used the adodbapi module against an SQL Server Express database. I was surprised to get an exception, when I attempted to submit a second query with my cursor object. The full session is below. With cx_Oracle I've become used to reusing a cursor for subs

Re: [DB-SIG] Saving composed objects.

On Thu, 2008-07-10 at 19:41 +0200, Federico Di Gregorio wrote: > On Thu, Jul 10, 2008 at 01:19:02PM +0100, Heston James - Cold Beans > wrote: > > I'm looking for your thoughts and advice on saving composed objects > to the > > database using the db API. Where do you place your persistence code? > F

Re: [DB-SIG] Parameter substitution and "IN" operator

On Tue, 2008-03-18 at 00:14 +0100, Gerhard Häring wrote: > This is not the way SQL parameter binding works. SQL parameter binding > only works with scalars (*). If tuples seem to work, then that's just > a side-effect of the implementation of your particular DB-API module. >>From here, it seems li