On 12/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > "SELECT SUM(reg), SUM(ot), SUM(ce), SUM(hol), SUM(sklv), SUM(vac), > SUM(ct), SUM(conv), SUM(misc) FROM tbl_TimeEntries WHERE dateworked >= > '12/31/2006' AND dateworked <= '01/13/2007' AND empid = 281"
The first and third return the correct sums. The middle one returns a > list of null values. Run sqlite <your_database_file> and check, if there is any NULLs in rows WHERE dateworked >= '12/31/2006' AND dateworked <= '01/13/2007' AND empid = 281" AFAIR if any row in sum have null value, the sum would be null. If I select everything in the database for that user, I get this: > > [(u'12/18/2006', 281, 8.0, u'', u'', u'', u'', u'', u'', u'', u'', > u''), (u'12/19/2006', 281, 8.0, u'', u'', u'', u'', u'', u'', u'', > u'', u''), (u'12/20/2006', 281, 8.0, u'', u'', u'', u'', u'', u'', > u'', u'', u''), (u'12/21/2006', 281, 8.0, u'', u'', u'', u'', u'', > u'', u'', u'', u''), (u'12/22/2006', 281, 8.0, u'', u'', u'', u'', > u'', u'', u'', u'', u''), (u'12/25/2006', 281, 8.0, u'', u'', u'', > u'', u'', u'', u'', u'', u''), (u'12/26/2006', 281, 8.0, u'', u'', > u'', u'', u'', u'', u'', u'', u''), (u'12/27/2006', 281, 8.0, u'', > u'', u'', u'', u'', u'', u'', u'', u''), (u'12/28/2006', 281, 8.0, > u'', u'', u'', u'', u'', u'', u'', u'', u''), (u'12/29/2006', 281, > 8.0, u'', u'', u'', u'', u'', u'', u'', u'', u''), (u'01/01/2007', > 281, 8.0, u'', u'', u'', u'', u'', u'', u'', u'', u''), > (u'01/02/2007', 281, 8.0, u'', u'', u'', u'', u'', u'', u'', u'', > u''), (u'01/03/2007', 281, 8.0, u'', u'', u'', u'', u'', u'', u'', > u'', u''), (u'01/04/2007', 281, 8.0, u'', u'', u'', u'', u'', u'', > u'', u'', u''), (u'01/05/2007', 281, 8.0, u'', u'', u'', u'', u'', > u'', u'', u'', u''), (u'01/08/2007', 281, 8.0, u'', u'', u'', u'', > u'', u'', u'', u'', u''), (u'01/09/2007', 281, 8.0, u'', u'', u'', > u'', u'', u'', u'', u'', u''), (u'01/10/2007', 281, 8.0, u'', u'', > u'', u'', u'', u'', u'', u'', u''), (u'01/11/2007', 281, 8.0, u'', > u'', u'', u'', u'', u'', u'', u'', u''), (u'01/12/2007', 281, 8.0, > u'', u'', u'', u'', u'', u'', u'', u'', u''), (u'01/15/2007', 281, > 8.0, u'', u'', u'', u'', u'', u'', u'', u'', u''), (u'01/16/2007', > 281, 8.0, u'', u'', u'', u'', u'', u'', u'', u'', u''), > (u'01/17/2007', 281, 8.0, u'', u'', u'', u'', u'', u'', u'', u'', > u''), (u'01/18/2007', 281, 8.0, u'', u'', u'', u'', u'', u'', u'', > u'', u''), (u'01/19/2007', 281, 8.0, u'', u'', u'', u'', u'', u'', > u'', u'', u''), (u'01/22/2007', 281, 8.0, u'', u'', u'', u'', u'', > u'', u'', u'', u''), (u'01/23/2007', 281, 8.0, u'', u'', u'', u'', > u'', u'', u'', u'', u''), (u'01/24/2007', 281, 8.0, u'', u'', u'', > u'', u'', u'', u'', u'', u''), (u'01/25/2007', 281, 8.0, u'', u'', > u'', u'', u'', u'', u'', u'', u''), (u'01/26/2007', 281, 8.0, u'', > u'', u'', u'', u'', u'', u'', u'', u'')] > [(80.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0)] > Sorry, but this is unreadable. Try to execute your queries via sqlite shell. -- Vladimir Rusinov GreenMice Solutions: IT-решения на базе Linux http://greenmice.info/
-- http://mail.python.org/mailman/listinfo/python-list
