[pysqlite] Escaping chars and LIKE statements

hi,

Im trying to get this statement work:

cur.execute("select * from history where timestamp "+timecondition+"? and "
+"(finalpath like ?/% or finalpath like ?) order by timestamp
DESC",(timestamp,path,path))

For some reason, ? and % dont get on well, and the statement crashes near %.
Whats the way to escape that and keep it working?

Thanks

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite