[PyQt] to display cotent of database between two dates

[atlass218]

I modify the line 11 of the code of the function (select_by_dates ):

def select_by_dates (self):
               
    start_date =self.lineEdit_start_date.text()             
    end_date = self.lineEdit_end_date.text()
             
    try :
         
        conn = sqlite3.connect ('correction.db')
        curseur=conn.cursor()
      
		curseur.execute('SELECT * FROM correction_loc35R  where  date_correction between ? AND ? ORDER BY date_correction DESC', (start_date, end_date))
                     
         
        liste_select_by_dates_correction=c.fetchall()
        nbr_rows=len(liste_select_by_dates_correction)
                   
        if nbr_rows != 0 :
             
            # set row count
            self.tableWidget_select_by_dates_correction.setRowCount(nbr_rows)
                     
            for nb in range(nbr_rows):
                for nombre in range(10):
                self.tableWidget_select_by_dates_correction.setItem(nb,nombre, QTableWidgetItem(liste_select_by_dates_correction[nb][nombre]))
                 
            self.tableWidget_select_by_dates_correction.resizeRowsToContents()
            self.tableWidget_select_by_dates_correction.resizeColumnsToContents()        
                         
        conn.commit()
        curseur.close()
        conn.close()
        else :
            print("OK")
 
        except :
            print("error")

but always the same probleme like there is no data in database