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?
Respectfully,
^_^
Sorry.. I didn't describe what I need as well as I thought I had.
Say I have a table for articles that all appear on a page:
ArticleID Title Content SortOrder Date
1 Title A Content A 3 2012-07-07
2 Title B Content B 1 2012-07-09
3 Title C Content C 4 2012-07-17
4 Title D Content D 2 2012-07-27
On the page that displays these articles, they appear in order from top to bottom:
Title B
Title D
Title A
Title C
But someone wants to rearrange the order in which they appear.
Title D
Title A
Title C
Title B
I prefer a drag n drop approach, but if that isn't possible/feasible, I'll appreciate suggestions.
Thank you,
^_^
North America
Europe, Middle East and Africa
Asia Pacific