I suspect you mean that you know how to use java script to change the display of the list when the user clicks the Up or Down arrow at the right hand side next to an item in your list.
If it were my list I would have the arrow post to the server and update the database and repopulate the list. Each arrow would hold the id of the item being moved and the id of the item it is to be swapped with if the arrow were to be clicked on. UpArrow = actionSwitchUp.cfm?ID1=xxx&ID2=yyy DownArrow = actionSwitchDown.cfm?ID1=xxx&ID2=yyy or combine it all into one actionSwitch and just swap the two id's passed in... or... there are as many ways to skin that cat as there are readers reading this list. Hope this helps, Brian At 05:52 PM 9/6/02, you wrote: >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 > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
