MySQL Forums
Forum List  »  Connector/Python

Advanced Search
New Topic

Re: SQL SYNTAX ERROR IN PYTHON CODING
Posted by: Huu Da Tran
Date: April 15, 2009 11:33AM 

no = cur.execute("select * from project.inv_list where Product_name like %s%%",(a1))

You need to double the percent sign, in your case, but that could be subject to SQL injection.

Huu Da
MySQL flirter

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
SQL SYNTAX ERROR IN PYTHON CODING
Sampath Girish Munagala
April 15, 2009 06:46AM
Re: SQL SYNTAX ERROR IN PYTHON CODING
Huu Da Tran
April 15, 2009 11:33AM
Re: SQL SYNTAX ERROR IN PYTHON CODING
Sampath Girish Munagala
April 16, 2009 12:46AM
Re: SQL SYNTAX ERROR IN PYTHON CODING
Huu Da Tran
April 20, 2009 11:51AM
Re: SQL SYNTAX ERROR IN PYTHON CODING
Irzha kenZu
May 24, 2009 01:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.