Dear SQLObject, i have problem with using groupBy parameter in sqlbuilder.Select class. actually i want to specify more grouping clause (not only one)
here is my code: whereSum = sqlbuilder.func.year(ts_times.q.startTime) == 2006 fieldsSum = [ts_times.q.uid, sqlbuilder.func.yearweek(ts_times.q.startTime), sqlbuilder.func.sum(sqlbuilder.func.timediff(ts_times.q.endTime, ts_times.q.startTime))] sql = conn.sqlrepr(sqlbuilder.Select(fieldsSum, whereSum, orderBy=ts_times.q.uid, groupBy="ts_times.uid, yearweek(ts_times.startTime)")) it doesn't work well gives back only one row??? if i use list, or tuple for groupBy i receive an sql error i assume the same syntax should be applied for orderBy. am i right? -- Best regards, Ivan Horvath Chief Programmer Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
