This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I noticed sometimes, when I try to retrieve data using the sql format of:
self.cursor.execute('SELECT FROM tablename WHERE column1 LIKE ? OR column2 LIKE ? OR column3 LIKE ?' , (searchbox, searchbox, searchbox) )
It usually gives me an error message: ODBC SQL server (SQL Server) Must declare the scalar variable "P160R". [SQL Server statement could not be prepared]
What sort of shit is this?
Hm, I don't exactly what is going on here, but I get the feeling that you are using the very old ODBC driver that comes with the OS. What does your connection string look like?
cursor.execute is a Python command. This is a Microsoft SQL Server forum, not a Python forum. Please post your question on a Python forum.
The error message very clearly indicates that it comes from SQL Server. cursor.execute is obviously a client-side thing, so it can be different engines.
Sorry, I said MySQL and meant Python. I corrected my post.
Hi @CEO ,
It seems that you use Python to retrieve data .
Please have a try like below, replace apostrophe with double quotes and make three searchboxes different.
cursor.execute("SELECT FROM tablename WHERE column1 LIKE ? OR column2 LIKE ? OR column3 LIKE ?" , (searchbox1, searchbox2, searchbox3) )
ODBC SQL server (SQL Server) Must declare the scalar variable "P160R". [SQL Server statement could not be prepared]
You could find out where is "P160R" from. It is from one procedure,function or other.
Then you could troubleshoot the relationship between the select statement and variable "P160R".
You could also use a new verison of ODBC driver and have another try.
Please provide more details then we could check further.
Thank you for understanding!
Best regards,
Melissa
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
My guess is one of the values you are passing is "P160R", and you probably need something like:
self.cursor.execute('SELECT FROM tablename WHERE column1 LIKE ''?'' OR column2 LIKE ''?'' OR column3 LIKE ''?''' , (searchbox, searchbox, searchbox) )
I would expect that to produce three instances of the error "Invalid column name '?'." The parameter placeholders should definitely not be quoted.