do you mean something like this:
item seq ======= eggs 1 cheese 2 bacon 3 tomatos 4 then if you move tomatos up 1 position you'll need to only swap the seq no's for bacon and tomatos. or if you move tomatos to the top then you'll have to resequence every record. >>> [EMAIL PROTECTED] 14/04/2005 11:23 am >>> On 4/14/05, Steve Onnis <[EMAIL PROTECTED]> wrote: > you could use a select box with some buttons to move the items up and down, > then use the position in the list when it gets submitted to re order your > items Hi Steve, I probably wasn't very clear in my description because I didn't go into the actual method of displaying it, but that's kind of what I'm doing. I just have 4 buttons on each item, (top,up,down,bottom). My question was more to do with the method of storing the priority to make it more efficient in terms of database access. I don't want to have to update every record every time I change the priority on an item. -- Jason Sheedy www.jmpj.net --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
