search

domhnallmorr / Tk-Path-Finder

Windows File Explorer/Manager with Tabs. Written in Tkinter using ttkbootstrap.
MIT License
15 stars 4 forks source link

Diary Sqlite Error #30

Closed domhnallmorr closed 2 years ago

domhnallmorr commented 2 years ago

The following text generates an error;

Hi Therese, I'm looking for an OP number for a proposal I'm working on

self.cursor.execute(f"UPDATE diary SET text = '{txt}' WHERE datestamp = '{date}'") sqlite3.OperationalError: near "m": syntax error

Possibly due to the , and ' at the beginning of the sentance.

domhnallmorr commented 2 years ago

Possible solution here https://stackoverflow.com/questions/7714321/with-python-sqlite3-module-how-to-deal-with-fields-that-contain-double-quotes

domhnallmorr commented 2 years ago

Resolved V0.33.2