[PyQt] to display cotent of database between two dates

[Denni]

Yes and if you look at what was printed -- which by the way is what you send to the database as a query -- you can see that the first one (which works) sends a proper SQL Statement -- while the second one does not for the database would not have any way of interpretting what you mean by start_date and end_date especially when its comparing those to a Date field.

I was (1) trying to show you how to validate your SQL Statements and (2) hoping that you would understand the issue once you printed out what it is you are actually sending to the database.

Typically I create my SQL In Code Statements as follows (especially if I am using variables to supply the parameters):

strDbSQL = ''
strDbSQL += 'SELECT * '
strDbSQL += '  FROM correction_loc35R '
strDbSQL += ' WHERE date_correction between '
strDbSQL += start_date.strftime('%m-%d-%Y')
strDbSQL += '   AND '
strDbSQL += end_date.strftime('%m-%d-%Y')
strDbSQL += ' ORDER BY date_correction DESC'

This makes it easy to read and allows for easier insertion of more statements as needed