sql select query issue in python

Question

I am running following command to fetch data of particular customer but output comes out to be null or no data found, while data is already stored in the table. Can anyone identify the problem

custid=input("Enter CustomerID:")  
cur.execute("""SELECT * FROM INFYCAMPUSCONNECT.CUSTOMER WHERE CUSTOMERID= :1 """ , (custid))

Just tried using %s. It give following error:cx_Oracle.DatabaseError: ORA-01036: illegal variable name/number — Aniket Jain
– Aniket Jain, Commented Jun 13, 2018 at 19:29
We need more information. Which database backend are you using? Which module do you use to connect to it? What are you typing? What is the type of the column in the database? What results do you get? Edit the question and add full error traceback? — nosklo
– nosklo, Commented Jun 13, 2018 at 19:30
@Barmar :1 is correct for some databases. Unfortunately there is no information in the question. — nosklo
– nosklo, Commented Jun 13, 2018 at 19:34

Barmar · Accepted Answer · 2018-06-13 19:48:01Z

2

The parameters need to be a tuple, so you have to put a comma in the parentheses:

cur.execute("""SELECT * FROM INFYCAMPUSCONNECT.CUSTOMER WHERE CUSTOMERID= :1 """ , (custid,))

answered Jun 13, 2018 at 19:48

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

sql select query issue in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related