%d format: a number is required not list

by

The mentioned query format is not secure, you can try binding in this way:

self.conn.execute('SELECT column1 FROM table_name WHERE column2 = ?', (number,))

According the docs (Sqlite3 Docs):

# Never do this -- insecure!
symbol="RHAT"
c.execute("SELECT * FROM stocks WHERE symbol="%s"" % symbol)

# Do this instead
t = ('RHAT',)
c.execute('SELECT * FROM stocks WHERE symbol=?', t)

More Related Contents:

  1. How can i calculate Caltalan numbers without a for loop?
  2. How to click on a element through Selenium Python
  3. How to run independent transformations in parallel using PySpark?
  4. Installing Pygame on 64-bit Windows 7 and 64-bit Python 2.7
  5. How to do slice assignment in Tensorflow
  6. Set scientific notation with fixed exponent and significant digits for multiple subplots
  7. Inserting a table name into a query gives sqlite3.OperationalError: near “?”: syntax error
  8. cv2.imread always returns NoneType
  9. “This browser or app may not be secure” error while attempting to login in to Gmail account using GeckoDriver Firefox through Selenium and Python
  10. Python struct.pack() behavior
  11. How to control the download of files with Selenium + Python bindings in Chrome
  12. When is it better to use zip instead of izip?
  13. appcfg.py not working in command line
  14. Use a loop to plot n charts Python
  15. how to draw multigraph in networkx using matplotlib or graphviz
  16. Pyspark filter dataframe by columns of another dataframe
  17. How to Navigate to a New Webpage In Selenium?
  18. print python emoji as unicode string
  19. I have wrong results with sorting function at python
  20. Python Pandas Data frame creation
  21. Pandas Bad Lines Warning Capture
  22. Why doesn’t chained (interval) comparison work on numpy arrays?
  23. Using my own corpus instead of movie_reviews corpus for Classification in NLTK
  24. Move and replace if same file name already exists?
  25. Retrieve S3 file as Object instead of downloading to absolute system path
  26. Pycharm environment different than command line
  27. Quick implementation of character n-grams for word
  28. Using scipy curve_fit for a variable number of parameters
  29. SparkSQL on pyspark: how to generate time series?
  30. String formatting [str.format()] with a dictionary key which is a str() of a number

Leave a Comment