checkboxes in a group the same thing), and count how many are checked. If
it's two, great, otherwise show an error message and don't let the form
submit.
Cheers,
barneyb
> -----Original Message-----
> From: Jillian Carroll [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 11:35 AM
> To: CF-Talk
> Subject: Limiting User to Select 2 Checkboxes per Group
>
> Hey!
>
> I've got a project where I've got 5 groups of golfers... and
> I need folks to
> be able to choose up to 2 golfers per group... no more, no less.
>
> Anybody have any advice on how best to do this?
>
> This is what I have so far:
>
> <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">#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">#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">#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">#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">#golfer_initial# #golfer_name#<br />
> </cfloop>
> </td>
> </tr>
> </table>
> <input type="submit" value="Save Changes">
> </form>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
