Hello list. I am trying to do something that I know has been done before.
I have a list of promotions that I am getting from a database, and listing them by a field called Order. These promotions also have a unique ID with them. I output them to a table and, to the right of each promotion title there is an up/down arrow so that the user can move them around. I know how to move them around in the browser, but I want to actually update the order in the database. The problem that I am having is making sure that I only change the order of the promotion just one above or below it, as well as the one I am moving. I am passing in the promotion ID and the Order number of the promotion that I want to move. So, how do I query for the record immediately above or below the one that I am moving? Does this make sense? Thanks in advance, Bruce ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
