D
Dave Harrison
Im sure this is a really obvious problem but :
self.curs.execute(
"""SELECT * FROM user WHERE login LIKE '%%s%'""", [login]
)
will not work ... gives me an "unsupported format character ''' (0x27)"
escaping the %'s with % as the doco recommends wont work either.
however this :
self.curs.execute(
"""SELECT * FROM user WHERE login LIKE '%dave%'"""
)
does work
so what's the go ?
cheers
Dave
self.curs.execute(
"""SELECT * FROM user WHERE login LIKE '%%s%'""", [login]
)
will not work ... gives me an "unsupported format character ''' (0x27)"
escaping the %'s with % as the doco recommends wont work either.
however this :
self.curs.execute(
"""SELECT * FROM user WHERE login LIKE '%dave%'"""
)
does work
so what's the go ?
cheers
Dave