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

Report · Jul 15, 2018

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

Report · Jul 17, 2018

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.

https://www.irt.org/articles/js140/#8

Published on: Saturday 2nd January 1999 By: Janus Boye