Hi and thanks, I was hoping to avoid having to weld qmarks together but I guess that's why people use things like SQL alchemy instead. It's a good lesson anyway.
Thanks, Marc. On Jul 30, 2:24 pm, Tim Golden <[EMAIL PROTECTED]> wrote: > Gerhard Häring wrote: > > My code would probably look very similar. Btw you don't need to use > > list() on an iterable to pass to executemany(). pysqlite's executemany() > > accepts anything iterable (so generators work fine, too). > > Thanks for that. My finger-memory told me to do that, possibly > because some *other* dbapi interface only accepts lists. Can't > quite remember. I'm usually all in favour of non-crystallised > iterators. > > > Also, with SQLite you can just skip data type definitions like > > VARCHAR(200). They're ignored anyway. > > Heh. Once again, finger memory forced me to put *something* > in there. I've been developing Enterprise databases for too > long :) > > TJG -- http://mail.python.org/mailman/listinfo/python-list
