2 replies to this topic

[mutago]

please guys Am using this code to query the database and is working but when i want to use parameter in the sql where clause,
it does not work again, i knew may be am using wrong parameter. any help please

 rs = con.query("SELECT * from product where price = '200')

this works but when used parameter %s in the where clause as showed below, it stop working

 rs = connection.query("SELECT * from product where price = '%s')

Okay in Python, i have achieved it this way

rs = "SELECT * FROM product where price='%s'" % (price)

thanks

[fread]

 rs = con.query("SELECT * from product where price = '200')

I don't think you need to put 200 in single quotes.

[mutago]

well whether 200 is surround by single quote or not its working. What am saying is that i need to make the selection
using a parameter symbols that will replace the 200 so that the code will look like

rs = connection.query("SELECT * from product where price = [B]'%s'[/B]")

see in python below i did it this way and is working

rs = "SELECT * FROM product where price='%s'" % (price)