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
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
