[EMAIL PROTECTED] wrote:
> I'm getting the following error:
>
> pysqlite2.dbapi2.OperationalError: no such table: tbl1
>
> Here's my code:
>
> from pysqlite2 import dbapi2 as sqlite
> con = sqlite.connect(":memory:", detect_types=sqlite.PARSE_COLNAMES)
> cur = con.cursor()
> cur.execute("select * from tbl1")
> data = cursor.fetchall()
> for record in date:
> record[0], record[1]
>
> my installation versions:
>
> python 2.4.2
> pysqlite 2.0.7
> sqlite 3.3.4
>
> I checked to make sure I have a table called tbl1.
where?
> I don't understand what's going on. Any ideas?
last time I checked, connect(":memory:") creates a new blank database
every time it is called.
</F>
--
http://mail.python.org/mailman/listinfo/python-list
