Tim Chase wrote: > Which follows the pattern > > UPDATE tbl > SET field = ( > SELECT SUM(field) > FROM tbl > WHERE [EMAIL PROTECTED] or [EMAIL PROTECTED] > ) - field > WHERE [EMAIL PROTECTED] or [EMAIL PROTECTED] > > Any help? > > -tkc (aka "the atomic swapper"? :)
Hehehe, that's a pretty neat trick... Could you write that in django ORM for me? ;-))) Seeing I only need to do this very infrequently, I think I'll just do the 3 saves... tmp = items.__class__.order_by("-field")[0].field + 1 tmp, i1.field = i1.field, tmp i1.save() i1.field, i2.field = i2.field, tmp i2.save() i1.save() ugly, but gets the job done... - bram --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---