no support for ORDER BY in db.update
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
web.py |
New
|
Undecided
|
Unassigned |
Bug Description
Although UPDATE ... SET ... ORDER BY .... is valid SQL, current db module doesn't support this. Current documentation shows arguments for db.select works for db.update, and there's no mention about order is not working in update.
Supposed to be work:
ret = self.db.
Result:
ERR: UPDATE Articles SET order = 'aIndex DESC', aIndex = aIndex + 1 WHERE bSerial = 1371L AND aIndex >= 48L
Finally:
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order = 'aIndex DESC', aIndex = aIndex + 1 WHERE bSerial = 1371 AND aIndex >= 48' at line 1")
Moved this issue to github
https:/ /github. com/webpy/ webpy/issues# issue/31