Skip navigation
Currently Being Moderated

CF9 - Change sort order for recordset from db (Oracle)

Aug 3, 2012 1:14 PM

Hello, everyone.


I'm tasked with a project part of which involves using a form to change the sort order of data retrieved from an Oracle (10g production, 11g development) database.  I've never had to do anything like this, before, so I'm at a bit of a loss as to how to go about it.


I've been considering using the jQuery-UI draggable feature, but don't know how to save the data back to the database.


WIth or without the jQuery-UI, what do you think is the best way to go about this?





  • Currently Being Moderated
    Aug 3, 2012 3:40 PM   in reply to WolfShade

    do it in your query.


    sort by #form.order_by_field#

    Mark as:
  • Currently Being Moderated
    Aug 4, 2012 2:50 AM   in reply to WolfShade

    Put a JQuery table sorter on it.  It's pretty straight fwd.  I don't think you want to bounce back to the server to effect some sorting for the UI, if possible: just do it on the UI.




    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points