SQLite Forum

Empty condition string in python
Login

Empty condition string in python

(1) By anonymous on 2020-04-22 23:11:40

If i fill the parameter for a condition in python it will search and fetch me the results but if i leave it empty it will search for empty. I want it to print everything from that column as if there was no condition, but as you know im stuck with the = sign or “is” while writing my condition

(2) By Warren Young (wyoung) on 2020-04-23 02:37:46 in reply to 1 [link]

You're probably calling the wrong function in your Python database API, one which always includes a SQL `WHICH` clause, but you want to have no `WHICH` clause at all.

You really need to post some of your code to get more specific advice.