Grazie mille Massimo, It is indeed what I was looking for :-)
On Sunday, February 10, 2013 5:19:55 PM UTC+1, Massimo Di Pierro wrote: > > I think you want: > > booked = db.booking.seats.sum().coalesce_zero() > > On Sunday, 10 February 2013 02:53:40 UTC-6, Calycé wrote: >> >> 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.