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]
