March 8th, 2004, 01:42 PM
Sort Order - ideas!
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.
March 8th, 2004, 06:32 PM
Send a URL to your example
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?
Cold Fusion Shopping Cart
March 10th, 2004, 08:24 PM
Can't you just update the sort order values in the table when the user clicks move up or move down?
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?