[pysqlite] InterfaceError: Error binding parameter 1 - probably unsupported type.

"Eric S. Johansson" <[email protected]> Tue, 11 Nov 2008 17:55:35 -0500
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
I don't understand why  I'm getting this because I specified type text and I'm
giving it a single string.  This string is a many line e-mail message in case
that makes a difference.  the SQL statement is:

insert into message_table (raw_message, xforward, recipient_list,
message_originator, state) values (?, ?, ?, ?, ?)

I printed the type of the first argument and I got <type 'str'>

I've tried to normalize the first argument through string escapes etc. but, it
makes no difference.

What am I being blonde[1] about this time?


---eric

[1] and I can say that because I am... was blonde. now more brown with strands
of gray caused by sql.