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.

Please, check How to Ask. Don't post images of code, error, etc. Copy/paste as formatted text here. — buran
– buran, Commented Oct 19, 2021 at 9:36
Please try to explain the question more briefly copy your code and use it with an answer explain how you are using post etc. — Aditya Dev
– Aditya Dev, Commented Oct 19, 2021 at 9:43

Siddhartha Kakaraparthy · Accepted Answer · 2021-10-19 17:34:02Z

1

pass values for the placeholders like

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

answered Oct 19, 2021 at 17:34

Siddhartha Kakaraparthy

212 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user17190275 Over a year ago

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 Over a year ago

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

Collectives™ on Stack Overflow

Python database query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related