Hi Les, I'm sure everyone will suggest that you don't use CFUPDATE. It is very restrictive, because it ties the names of your form fields to the names of your database fields (as you know). You really want to break the direct relationship between database and form. In other words, the design of the form and the design of the database should be joined together by a intermediate translation layer (in this case a SQL query) that knows which form fields relate to which database fields. CFUPDATE is an interesting shortcut, but as you can now see, it leads to uncomfortable fudging. Sorry for the rant. Have fun Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -----Original Message----- From: Les Irvin [mailto:[EMAIL PROTECTED]] In my application, users are updating a database via a form. Is it possible to dynamically change a form field name - say from "order1" to "order" - after the form is submitted but before the <cfupdate> tag is processed? If so, how could it be done? IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
