SQL Using Variable Value

Question

I have a variable like below in python;

run_id=5654

When i execute the below code;

df=curs.execute("select* from [DATABASE] where RunId=run_id")

I got an error:

DataError: ('22018', "[22018] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'run_id' to data type smallint. (245) (SQLExecDirectW)")

Could you please help me about this? How can i proceed?

You need to learn how to pass a variable to your query as a parameter — Ilyes
– Ilyes, Commented Nov 1, 2019 at 13:40
Possible duplicate of How to use variables in SQL statement in Python? — Buckeye14Guy
– Buckeye14Guy, Commented Nov 1, 2019 at 13:42

Tim Biegeleisen · Accepted Answer · 2019-11-01 14:06:12Z

1

Assuming you are connecting to your SQL Server instance using pyodbc, you should use a prepared statement with ? as the placeholder:

run_id = '5654'
df = curs.execute("SELECT * FROM [DATABASE] WHERE RunId = ?", (run_id,))

edited Nov 1, 2019 at 14:06

answered Nov 1, 2019 at 13:45

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

2 Comments

Salih Over a year ago

yeah you are right, but i got this error: ProgrammingError: ('Invalid parameter type. param-index=0 param-type=numpy.int64', 'HY105')

Tim Biegeleisen Over a year ago

It appears that the RunId column is some sort of text. Then you need to bind a string variable, q.v. my updated answer.

Collectives™ on Stack Overflow

SQL Using Variable Value

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related