Hello, I apologize for being OT here, but I'm hitting a brickwall. I've built a page that displays several records--all of which can be edited and/or turned on or turned off from a display perspective (editable textbox and checkbox).
Unfortunately, my SQL experience doesn't lend to me being able to figure out how to loop through all the IDs of the fields I've just displayed and then update them. I'm running on RH 7.2 and MySQL--and I'm trying to find the best way to update multiple records, and I've not found any information on how to do this--can anyone help me find a way to do this for multiples instead of having to modify records one at a time? Thanks, Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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