Python 3.4 mysql SELECT / WHERE query - syntax problem

Try using single quotes around the %s like: '%s'  That's what is normally expected in a MySQL query.  My little MySQL Py demo has the sql string set up differently.

sql = "select * from members2 \
      where nom = '%s' " %(name))

Select allOpen in new window

Thanks for looking at this Dave.  No luck so far I'm afraid.  I have tried your string set up with and without the " on the  %s.  I show the strings and the error codes below.  I have also tried the string set up I used with and without the '' on the %s and I show the strings and error codes below.  

As you know, I am using python 3 and my reading of the results below suggests that the %s should not be bracketed. The strings in the error messages seem distorted when the " are used ??  

But either way, the problem is not solved.   If I forget the WHERE clause ... sql = ("SELECT * FROM members2")..
I do get the full set of data printed out.

Below is the function which I use for printing out the data - maybe there is a problem there when the WHERE clause is used?

def displayAll_names(all_names):
      print("<table border='1'>")
      print("<tr>")
      print("<th>Member_ID</th>")
      print("<th>civilities</th>")
      print("<th>PreNom</th>")
      print("<th>Nom</th>")
      print("<th>adresse</th>")
      print("</tr>")
      for each in all_names:
            print("<tr>")
            print("<td>{0}</td>".format(each[0]))
            print("<td>{0}</td>".format(each[1]))
            print("<td>{0}</td>".format(each[2]))
            print("<td>{0}</td>".format(each[3]))
            print("<td>{0}</td>".format(each[4]))
            print("</tr>")

      print("</table>")	        

Select allOpen in new window

Tks again for the help,
james

ERROR MESSAGE TESTS

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '['kane', 'Submit']' at line 1

sql = ("select * from members2 \
      where nom = %s " %(name))  
     
 ................................................................................................................    
     
mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'kane', 'Submit']'' at line 1

     sql = ("select * from members2 \
      where nom = '%s' " %(name))  
     
 ======================================================================================
     
     
mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '['kane', 'Submit']' at line 2

 sql = ("""SELECT * FROM members2
      WHERE nom = %s """ %(name))
     
     .........................................................................................................................................
     
     
      mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'kane', 'Submit']'' at line 2
     
      sql = ("""SELECT * FROM members2
      WHERE nom = '%s' """ %(name))  
     
      =====================================================================================

The Python 3.4 code below is derived from the code on this page:  http://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html  I created several versions of it to check it.

import mysql.connector

config = {
  'user': 'username',
  'password': 'userpwd',
  'host': '10.202.46.41',
  'database': 'dibsites',
  'raise_on_warnings': True,
}

cnx = mysql.connector.connect(**config)

cursor = cnx.cursor()

query = ("SELECT ent_num, SortName, Descript FROM websitelist "
         "WHERE ent_num = '%s'" %(19))

wstart = "17"
wend = "92"

cursor.execute(query)

for (ent_num, SortName, Descript) in cursor:
  print("{}, {} was {}".format(
    SortName, Descript, ent_num))

cursor.close()
cnx.close()
print("Done with myseldibs.py")

Select allOpen in new window

Great !!!  problem solved.   All I needed to do was to add  name=name[0]   to the getData() function.

def getData():
      formData = cgi.FieldStorage()
      name = formData.getvalue('membername')
      name=name[0]
      return name

Thanks again for solution and learning AND for the extra example !!!

james

You're welcome, glad to help.