0

Having problems with the TypeError below:

order_list = ['25459 ', '12381 ', '25375 ']

cursor.execute("SELECT  WVGID6 , WVWHID, WVITNO, WVLOCA FROM WMRSV WHERE OHORNO IN (%s)"% tuple(order_list))
TypeError: not all arguments converted during string formatting

The correct SQL should look like:

SELECT  WVGID6 , WVWHID, WVITNO, WVLOCA FROM WMRSV WHERE OHORNO IN ('25459 ', '12381 ', '25375 ')
2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by woooee
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.