Unable to run select statement

[necavi]

This is my first time using PyMySQL, and unfortunately whenever I try
to use the tuple argument for cursor.execute I always get:
File "C:\Development\Language installs\Python\lib\pymysql
\cursors.py", line 105, in execute
query = query % escaped_args
TypeError: not all arguments converted during string formatting
but when using the exact same values directly in the query (as a test)
it executes flawlessly.

Any ideas on how I can prevent this?

[Pete Hunt]

Can you send your execute() line?

[necavi]

cur.execute("SELECT
`user_name`,`user_class`,`user_password`,`user_email` FROM
`irpg_users` WHERE `user_ID` = ?",(1,))
is an example (it also happens with INSERT statements and such)
cur.execute("SELECT
`user_name`,`user_class`,`user_password`,`user_email` FROM
`irpg_users` WHERE `user_ID` = 1")
executes flawlessly.

[Pete Hunt]

PyMySQL uses format-style to be compatible with MySQLdb, rather than
qmark-style like sqlite3.

Try changing ? to %s.

[necavi]

Ahhh, many thanks! I'm not familiar with MySQLdb, so I didn't think to
try that.