You can specify the list of formfields to be processed by the CFINSERT tag,
using the FORMFIELDS attribute. However, in my opinion, reliance on
CFINSERT can have unintended consequences. I recommend that you use a
CFQUERY with the appropriate SQL statements instead. This gives you more
flexibility and control in the long run.
DC
----- Original Message -----
From: SPENCER, Chris <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 11, 2000 15:40
Subject: HTML Form Submit button troubles
> Hi
>
> I'm new to ColdFusion and although I'm finding it generally easy going
> I'm
> having some troubles using CFINSERT to populate an Access database
> table.
> The trouble is that ColdFusion seems to be interpreting my Submit button
> as
> another form field in which it should be entering a value in the
> database
> table. Since I don't have a column in my database called 'SubmitForm'
> I'm
> getting the following error:
>
> Field name not found in the specified table. Table = 'DETAILS' Field =
> 'SUBMITFORM' The error occurred while processing an element with a
> general
> identifier of (CFINSERT).
>
> When I create a column for the sumbit button the actionpage works just
> fine.
> Does anyone know what I'm doing wrong?
>
> Chris Spencer
>
>
>
>
> Chris Spencer
> Learning Support Technician
> Cheltenham & Gloucester College of H.E
> Pallas Villa, Park Campus
> Cheltenham, UK
> 01242 532967.
> ------------------------------------------------------------------------
> ------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
