Hi all, Given a query like the following one: booked = db.booking.seats.sum() db(db.schedule.training==db.training.id).select(db.schedule.training_date,db .training.short_title, db.schedule.seats, db.booking.seats.sum(), groupby=( db.schedule.training_date,db.training.short_title,db.schedule.seats), left= db.booking.on(db.schedule.id==db.booking.training_date))
I'm retrieving the records I'm looking for except that for some of them I have no results in the summed column. These are for the records where there is no child record in the left table (booking). Is there a way to tell sum() to return 0 instead of None ? Thanks for your help -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
