This is for a golf pool --the idea is:
01. User comes to the page, selects 2 golfers from each 'group'.
02. No more than 2 golfers can be selected from each group.
I can get the golfers to list from the database without any difficulty...
the problems I'm having:
01. How can I translate my 'lists' into 'insertable'? What I mean is...
how I do I say 'take the two golfers from group one, call them golfer_1a and
golfer_1b and then do the SQL insert'?
02. How can I ensure that no more than 2 golfers are chosen from each
group?
Here is my form code (sql insert code is below):
<form name="team_info" action="" method="post">
<!--- Select all golfers from group 1. --->
<cfquery name="golfers1" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 1
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 1</b>
<br />
<cfloop query="golfers1">
<input type="checkbox" name="group_1"
value="#golfer_id#">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
<td>
<!--- Select all golfers from group 2. --->
<cfquery name="golfers2" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 2
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 2</b>
<br />
<cfloop query="golfers2">
<input type="checkbox" name="group_2"
value="#golfer_id#">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
<td>
<!--- Select all golfers from group 3. --->
<cfquery name="golfers3" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 3
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 3</b>
<br />
<cfloop query="golfers3">
<input type="checkbox" name="group_3"
value="#golfer_id#">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
<td>
<!--- Select all golfers from group 4. --->
<cfquery name="golfers4" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 4
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 4</b>
<br />
<cfloop query="golfers4">
<input type="checkbox" name="group_4"
value="#golfer_id#">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
<td>
<!--- Select all golfers from group 5. --->
<cfquery name="golfers5" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 5
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 5</b>
<br />
<cfloop query="golfers5">
<input type="checkbox" name="group_5"
value="#golfer_id#">#golfer_initial# #golfer_name#<br />
</cfloop>
</form>
*** *** ***
SQL Insert code:
<cfquery name="add" datasource="#DSN#" username="#db_username#"
password="#db_password#">
INSERT INTO teams (
team_id,
golfer_1a,
golfer_1b,
golfer_2a,
golfer_2b,
golfer_3a,
golfer_3b,
golfer_4a,
golfer_4b,
golfer_5a,
golfer_5b
)
VALUES (
nextval('"teams_team_id_seq"'::text),
'#form.golfer_1a#',
'#form.golfer_1b#',
'#form.golfer_2a#',
'#form.golfer_2b#',
'#form.golfer_3a#',
'#form.golfer_3b#',
'#form.golfer_4a#',
'#form.golfer_4b#',
'#form.golfer_5a#',
'#form.golfer_5b#'
)
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
