#9 update via execute does not work

[Harpreet Bhatia]

Update does not work
i have a simple code

today = str(time.strftime('%Y-%m-%d'))
        query = "update lb_inquiry_response set inquiry_response_status = 'expired' where validity_date <= '%s'" %(today)
        # print query
        result = self.db.execute(query)
        print result.affected_rows

i get the count but no updates are done to database records