#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    20
    Rep Power
    0

    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
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    11
    Rep Power
    0

    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?

    Marc
    Cold Fusion Shopping Cart
    support@ColdFusionCart.com

    www.ColdFusionCart.com
  4. #3
  5. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,265
    Rep Power
    968
    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?

IMN logo majestic logo threadwatch logo seochat tools logo