Peter: I built a system quite a few years back that let you reorder records. The front end was a select list showing all of the records and 2 buttons, up and down. When you were finished reordering the records, you'd push the submit button which would build a list of the elementIDs in the new order. The backend simply looped over the list and entered the new order number into the DB.
Email me offlist if you want the code (front and back). -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Tilbrook, Peter [mailto:[EMAIL PROTECTED] > Sent: Monday, March 10, 2003 6:43 PM > To: CF-Talk > Subject: Re-ordering table records > > > What would be the best (web based) way to provide a sorting feature of > records in a database table (eg: move up/down). > > Cheers! > > == > Peter Tilbrook > Internet Applications Developer > Australian Building Codes Board > GPO Box 9839 > CANBERRA ACT 2601 > AUSTRALIA > > WWW: http://www.abcb.gov.au/ > E-Mail: [EMAIL PROTECTED] > Telephone: +61 (02) 6213 6731 > Mobile: 0439 401 823 > Facsimile: +61 (02) 6213 7287 > > > ********************************************************************** > The information contained in this e-mail, and any attachments to it, is > intended for the use of addressee and is confidential. If you are not > the intended recipient, you must not use, disclose, read, forward, copy or > retain any of the information. If you have received this e-mail in > error, please delete it and notify the sender by return e-mail or > telephone. > The Commonwealth does not warrant that any attachments are free from > viruses or any other defects. You assume all liability for any > loss, damage, or > other consequences which may arise from opening or using the attachments. > > ********************************************************************** > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
