Sort Order - ideas!

Hi

I am working on a project. A requirement has come up for the ability to sort records in any order. The client requires the ability to be able to control the sort order of a table. To do this I have added a numeric sortOrder field to the dbase. By entering numeric values in the sortOrder column the client can readily control the resulting sort order in the output pages.

I would like to take this to the next level though and have a simple: move up | move down link that automatically moves the record up or down by changing the sortOrder column accordingly - this is the stumbling block thus far - and I am looking for ides on to how best implement this. Conceptually I thought this was going to be fairly straight forward - however I have been trying some ideas for a bit now and seem to be hitting some brick walls in how to best implement this.

So I thought a post to the forums might get me rolling ont he correct path....

Thanks in advance for any ideas. I have seen this approach in some sites.

Jeff

I can write you some code if you want.

Can you post an example URL or screen-shot of what you want?

It is easy for me to program, so send an example or go into more detail about what you want and I will write the code and post it to you.

What are the database field names you want to sort on?

Marc
Cold Fusion Shopping Cart
support@ColdFusionCart.com

www.ColdFusionCart.com

Can't you just update the sort order values in the table when the user clicks move up or move down?

So:
User clicks the 4th item out of 5 items to move it up.
You run a query to get the elements with sortid 4 and 5.
You update 4 so it is now sortid 5, and update 5 so it is sortid 4.

Is there a reason why that would not work?