Ordering Problem

[brobborb]

Hey guys, i have a Select list with anywhere from 200 to 3,000 items.  The items (corresponding to image files on the server) are displayed in order by a field in the database called "order_num".  now, the user has the ability to insert a new item into the list by doing this....Let's say they want a copy of item 33, they just select item 33, press the asterisk key on the keypad, and a copy of item 33 goes after it.  They can also move items up and down the list, to rearrange their order.  But this is just the front end, nothing has been added into the database yet, and nothing has really been created, it's just _javascript_. (so if they refresh the page, they will get what they had i the beginning)

This is where I am stuck as to how/when renumber the "order_num" field to work with the the re-arranged list.  I kinda got the "how" part.  I was thinking of submitting the whole list, along with their positions in the list using _javascript_ each time a new item is copied/added, or when items are moved up and down the list (the cfm file processing goes on in an invisible frame).  But what if the list contains 1,000 images.  That would mean 1,000 updates for every copy they make.  Could be quite a hassle.

Or, instead, how about they can move stuff around or copy items, and when they are satisfied, the press a "process" button to make changes into the database.  But that's not preferable, because i want things to be up to date, to avoid confusion.

Maybe there is a more efficient way to do this!

Thanks!

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---