Python database query

Question

I am having a problem with SELECT operation during CRUD operations. I want to pull the query from the database and throw it into a table. Why is %s error here? Can you help me?

 @app.route('/Index')
def querypage():
 cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
 error = ''
 if request.method == 'POST':
 PRODUCT = request.form['PRODUCT']
 PRICE = request.form['PRICE']
 sql = "SELECT * FROM TBSHOPING WHERE PRODUCT = %s && PRICE = %s"
 cur.execute(sql)
 productlist = cur.fetchall()
 return render_template('datatable.html', productlist=productlist)

Error:

 return super().execute(query, vars)
 psycopg2.errors.SyntaxError: syntax error at or near "%"
 LINE 1: SELECT * FROM TBSHOPING WHERE PRODUCT = %s && PRICE = %s

Edit:

I am using a sql statement in the query. I want to throw the data that will come from the database into the table I created in datatable.html. But I am getting %s error in my query sentence.

• buran: Please, check How to Ask. Don't post images of code, error, etc. Copy/paste as formatted text here.
• Aditya Dev: Please try to explain the question more briefly copy your code and use it with an answer explain how you are using post etc.
• user17190275: I fixed it, can you check it again?

Answer 1

pass values for the placeholders like

cur.execute(sql,(PRODUCT,PRICE))

• user17190275: Hi, thanks for comment. So what does this error mean? cur.execute(sql, (PRODUCT, PRICE)) # Execute the SQL UnboundLocalError: local variable 'PRODUCT' referenced before assignment
• Siddhartha Kakaraparthy: Hello, the error says that the if block may or may not execute but we are executing this statement cur.execute(sql, (PRODUCT, PRICE)) in which PRODUCT and PRICE are not assigned any value.So just assign some dummy value to those variable like PRODUCT ="NA" and PRICE =0 before if statement