Pascal
> -----Original Message-----
> From: Pascal Peters
> Sent: donderdag 11 maart 2004 14:58
> To: CF-Talk
> Subject: RE: Insert dynamic form fields into a database
>
> If your database is case-insensitive or golfer_id is uppercase (or
> numeric):
>
> <cfloop collection="#form#" item="field">
Replace previous line by
<cfloop list="#form.fieldnames#" index="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]
