numeric):
<cfloop collection="#form#" item="field">
<cfquery datasource="#DSN#" username="#db_username#"
password="#db_password#">
INSERT INTO tbl (golfer_id,golfer_purse)
VALUES (
<cfqueryparam cfsqltype="CF_SQL_CHAR" value="#field#">,
<cfqueryparam cfsqltype="CF_SQL_CHAR"
value="#form[field]#">
)
</cfquery>
</cfloop>
Else:
<cfquery name="golfers" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT golfer_id
FROM golfers
</cfquery>
<cfloop query="golfers">
<cfquery datasource="#DSN#" username="#db_username#"
password="#db_password#">
INSERT INTO tbl (golfer_id,golfer_purse)
VALUES (
<cfqueryparam cfsqltype="CF_SQL_CHAR"
value="#golfers.golfer_id#">,
<cfqueryparam cfsqltype="CF_SQL_CHAR"
value="#form[golfers.golfer_id]#">
)
</cfquery>
</cfloop>
> -----Original Message-----
> From: Jillian Carroll [mailto:[EMAIL PROTECTED]
> Sent: donderdag 11 maart 2004 14:38
> To: CF-Talk
> Subject: Insert dynamic form fields into a database
>
> I've got a form that is made up of a dynamic list of form
> fields. How do I write the SQL query so that it will loop
> over all of the fields to do the insert?
>
> My form:
>
> <cfquery name="golfers" datasource="#DSN#"
> username="#db_username#"
> password="#db_password#">
> SELECT *
> FROM golfers
> ORDER BY
> golfer_name
> </cfquery>
>
> <br />
> <form name="team_info" action=""
> method="post">
> <table border="0" cellpadding="1" cellspacing="0" width="98%"
> align="center">
> <tr>
> <td class="tableheader" width="125">Golfer</td>
> <td class="tableheader">Purse</td>
> </tr>
> <cfloop query="golfers">
> <tr>
> <td>#golfer_initial# #golfer_name#</td>
> <td><input type="text" name="#golfer_id#"
> value="#golfer_purse#"
> /></td>
> </tr>
> </cfloop>
> <tr>
> <td><input type="submit" value="Save Changes"></td>
> </tr>
> </table>
> </form>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]