You should use an affected variable something like <@assign local$neworder <@calc expr="<@currow>-<@var local$start>+1>"> when displaying your resultset and the new order will be ready to update
Hope this help Gauthier ----- Original Message ----- From: "Peter Fogg" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 6:48 PM Subject: Witango-Talk: Sort and Renumber question > I am sure I am just being retarded but I am having problems with something > that I thought would be relatively simple. > > I have a list of objects > > Identifier Original Order Priority > a 1 > b 2 > c 3 > d 4 > e 5 > changed the priority of c to 4 Identifier New Order Priority > a 1 > b 2 > c 4 <- changed to 4 > d 4 > e 5 > I want to then renumber the priority Identifier Final Order Priority > a 1 > b 2 > d 3 <- modified the priority > c 4 <- now in proper order > e 5 > > This is what I want to do. I hope this is clear enough, if not yell at me. I > want the item with a new priority to bump the item with its matching > criteria up. > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
