Skip to main content
mornings80
Participating Frequently
July 15, 2018
Question

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

  • July 15, 2018
  • 1 reply
  • 642 views

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

This topic has been closed for replies.

1 reply

mornings80
Participating Frequently
July 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