What about creating a database view with the corrected name? This way, you don't have to change your Cold Fusion generated SQL, except for the table/view name or the actual database layout.
Steve ------------------------------------- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com ------------------------------------- -----Original Message----- From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 6:08 PM To: CF-Talk Subject: RE: Strangest Problem in a long time Dave, I'm using this in a large site where the SQL is generated based on the fieldname. fieldnameXXcolumnname is translated into: Insert into fieldname (columname) values ('#fieldnameXXcolumname#'); I will have to come up with an extra conversion step to change the name of these fields and then change them back. What a bummer. Leon -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 4:57 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: Strangest Problem in a long time > Because of the database_design I cannot change the name of my > fields. Is there any way I can turn this feature off? No, you can't turn the feature off, but you can certainly change the names of your form fields - there's no reason that they have to be identical in name to the database fields. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists