Re: [sqlite] select date using variables in Python

2007-12-12 Thread Mag. Wilhelm Braun
hi C M, I'm by no means an expert but what I do in similar cases is: I prepare the variables beforehand - actually I prepare the whole SQL statement beforehand and do normally not use ?. except by executemany. date=date("now","+1 day") sqlcu.execute ("SELECT string FROM test WHERE d

[sqlite] select date using variables in Python

2007-12-11 Thread C M
I'm new to SQLite and can't figure out the right way to write this. I want to select a range of dates, let's say anything beyond tomorrow So in my table called test I want to select the column called string based on the date being tomorrow or later... This statement (from the sql wiki about