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
Just for future reference in the unlikely event that anyone needs to do something similar, I found a great example that does exactly what I was looking for (written almost 20 years ago ). I hope this helps someone.