#9 update via execute does not work

v1.0_(example)
open
nobody
None
5
2016-01-07
2016-01-07
No

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

Discussion


Log in to post a comment.