Howard and everyone else that responded, Thanks for all your feedback. I will change my variable naming to sometime more like "_dateX" and then take off the X on the response page. This seems rather cludgy but I guess it will have to do. I feel rather peeved that there is no way in cold fusion to turn off this check feature. I'm sure lots of people have had problems with this!
Leon -----Original Message----- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 6:24 PM To: CF-Talk Subject: RE: Strangest Problem in a long time On your response page, try something like this: <cfset form.this_date="#form.thisdate#"> In other words, convert the "safe" form field names into what your SQL needs to read. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 > -----Original Message----- > From: Leon Oosterwijk [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 3: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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
