Having problem embedding strings into SQLite query in Python

Asked Mar 16 '22 at 09:21

Active Mar 16 '22 at 09:21

Viewed 27 times

I have a SQLite database with a datetime column like below and I do query using Python(import sqlite3):

First of all, the following query is successful:

sqlite_select_query = 'SELECT DateTime FROM myTable WHERE DateTime BETWEEN "2022-03-14 14:09:08" and "2022-03-15 17:04:51"'

But I want to make start and end dates user selectable and write the query in the following form:

startingDate = "2022-03-14 14:09:08"
endingDate =   "2022-03-15 17:04:51"

sqlite_select_query = 'SELECT DateTime FROM myTable WHERE DateTime BETWEEN '+startingDate+' and '+endingDate+'

But the above give the following error:

SyntaxError: EOL while scanning string literal

startingDate = "2022-03-14 14:09:08"
endingDate =   "2022-03-15 17:04:51"

Then I tried to add one more ' at the end as follows:

sqlite_select_query = 'SELECT DateTime FROM myTable WHERE DateTime BETWEEN '+startingDate+' and '+endingDate+''

But now the above doesn't select anything.

asked Mar 16 '22 at 09:21

GNZ

you are missing an ending ' – applesomthing Mar 16 '22 at 09:28
@applesomthing Yes I replaced ' with " and same issues – GNZ Mar 16 '22 at 09:30
Use parameter substitution to interpolate values; see [this answer](https://stackoverflow.com/a/902836/5320906) for sqlite syntax. – snakecharmerb Mar 16 '22 at 09:30
@gajendragarg Tried and that doesn't select anything either. – GNZ Mar 16 '22 at 09:32
Can someone help me they closed the question. And the link didn't help me either. – GNZ Mar 16 '22 at 09:38
and encapsulating it? ('SELECT DateTime FROM myTable WHERE DateTime BETWEEN '+startingDate+' and '+endingDate+') – applesomthing Mar 16 '22 at 09:38
@applesomthing Gives EOL error – GNZ Mar 16 '22 at 09:40
@gajendragarg Doesnt return anything – GNZ Mar 16 '22 at 09:40
@snakecharmerb Parameter sub didnt work – GNZ Mar 16 '22 at 09:50
Please vote to reopen the question. – GNZ Mar 16 '22 at 09:50
@gajendragarg It doesn't return anything at cursor.execute(sqlite_select_query) – GNZ Mar 16 '22 at 09:54
Last try: `sqlite_select_query = f"""SELECT DateTime FROM myTable WHERE DateTime BETWEEN "{startingDate}" and "{endingDate}" """` – gajendragarg Mar 16 '22 at 09:54
I'd consider voting to reopen if you [edit] the question to show how parameter substitution is not working. String formatting is absolutely the wrong way to do this. – snakecharmerb Mar 16 '22 at 10:19

Having problem embedding strings into SQLite query in Python

0 Answers0