method you will have errors generated by the submit button (unless you have
a field for it in the BD!) but the simple workaround is to have the submit
button with a blank name, ie:
<input type="submit" name="" value="Insert">
That should do it.
--
Jay
> -----Original Message-----
> From: Steve Brownlee [mailto:[EMAIL PROTECTED]
> Sent: 23 September 2004 13:56
> To: CF-Talk
> Subject: Re: Quick and Easy way to submit/enter all form fields
>
> I would say INSERT if you are 100% certain that all field
> names match up. However, if you want a manual way of doing
> it, here's a quick hack of a suggestion.
>
> <cfset columnList = "">
> <cfset valueList = "">
> <cfloop index="formField" list="#form.fieldnames#" delimiters=",">
> <cfset columnList = ListAppend(columnList, formField, ",")>
> <cfset valueList = ListAppend(valueList,
> form[formField], ",")> </cfloop>
>
> <cfquery name="q_insert_form_fields">
> INSERT INTO MyTable ( #columnList# ) VALUES ( #valueList# ) </cfquery>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
