Need to prioritize a list then insert the prioritized numbers back into the DB

I have a list of items in a database. I need a CF page that will allow a person to display all of the items and then prioritize (order) the list from "1 to n" and then have those prioritized numbers inserted back into the database.

It seems that I need to somehow combine a cfoutput query="Qry" (to list all of the items) with an <cfinput type="text"  (to add an order number) then have the order number inserted back into the database on the submit...but I would sure appreciate some initial guidance. I'm not sure I'm in the ballpark quite yet. TIA