CODEWITHSUNDEEP
databasesqlitepython-2.7
emay
emay

Reputation: 394

sqlite InterfaceError: Error binding parameter 0 - probably unsupported type

I am using sqlite3 python modules and th following code returns the error

InterfaceError: Error binding parameter 0 - probably unsupported type

Note I have already tried with normal (non unicode) strings and the result is the same

# get database cursor
cur = dbConnection.cursor()

# create table for prices
cur.execute( """
   create table if not exists
   prices( time text,                     
           mid integer, 
           exid text,
           selid integer,                     
           priceone real,
           sometext text,
           price2 real,
           primary key (time, mid, exid, selid, priceone)
           foreign key (time, mid, exid, selid) references selection(time, mid, exid,selid) )""" )

#insert price
tuple  = (u'20120228153239788135', 104982590, 1, 4764315, 1.99, u'B', 0.07)
cur.execute( "insert into prices values (?,?,?,?,?,?,?)", tuple)

Upvotes: 1

Views: 3443

Answers (1)

rjbez
rjbez

Reputation: 812

This code works fine for me.

However, have you changed your table schema at all? Because you add the 

 create if not exists

it is likely you changed something but the DB (file) wasn't updated since you have this.

Also, you are passing in an int for exid even though the type is text. It will automatically convert it but still shouldn't do it.

Upvotes: 2

Related Questions