Help with LIKE in a SelectSQL()

Databases
1

Hi!

I´m doing some testing and I can’t figure out what I’m doing wrong. This code works:

sql = "SELECT * FROM prueba "
sql = sql + "WHERE nombre LIKE '%" + tempString + "%' "
rs = self.db.SelectSQL(sql)

While this one returns nothing

sql = "SELECT * FROM prueba WHERE nombre LIKE '%?%' "
rs = self.db.SelectSQL(sql, tempString)

No exception is raised but I get no rows back.

Any idea what I might be doing wrong?

Thanks for any help.

2

try

sql = "SELECT * FROM prueba WHERE nombre LIKE ?"
rs = self.db.SelectSQL(sql, "%"+tempString+"%")
1 Like
3

[quote=466056:@Norman Palardy]try

sql = "SELECT * FROM prueba WHERE nombre LIKE ?" rs = self.db.SelectSQL(sql, "%"+tempString+"%") [/quote]

That works.

Thanks!!