sqlite binding error in python

Question

I'm having a problem with the binding in this sqlite3 statement in python. Any help would be apreciated. Thanks

print page
print section
cur.execute('SELECT * FROM docList WHERE pageFileName = ? AND sectionTitle = ?',(page,section,))

Here is the output

(u'current_reports.html',)
(u'Intro',)
Traceback (most recent call last):
  File "C:\Work\Dropbox\Public\www\propagateIndex.py", line 65, in <module>
    cur.execute('SELECT * FROM docList WHERE pageFileName = ? AND sectionTitle = ?',(page,section,))
InterfaceError: Error binding parameter 0 - probably unsupported type.
>>>

I have read a lot of other posts about this but I am not sure what to do still. Tried different

Martijn Pieters · Accepted Answer · 2013-05-16 21:31:35Z

1

page and section are tuples; you want to insert just the first elements. It's easiest just to concatenate these:

cur.execute('SELECT * FROM docList WHERE pageFileName = ? AND sectionTitle = ?',
            page + section)

or use indexing:

cur.execute('SELECT * FROM docList WHERE pageFileName = ? AND sectionTitle = ?',
            (page[0], section[0]))

answered May 16, 2013 at 21:31

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

John Over a year ago

Thanks so much, I always struggle with that!!

Collectives™ on Stack Overflow

sqlite binding error in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related