ColdFusion RSS ColdFusion RSS

Radio button problem and cfloop

Reply

•
•
Join Date: Sep 2008
Posts: 337
Reputation: freshfitz is an unknown quantity at this point 
Solved Threads: 27
freshfitz freshfitz is offline Offline
Posting Whiz

Radio button problem and cfloop

 
0
  #1
Aug 29th, 2009
How can I use cfloop or query my database so I can select home game and away game for multiple selections. I need to select 1 selection for home and away game but have to be able to select 1 of each. here is my output

http://67.219.102.67/wcfootball/index2.cfm

ColdFusion Syntax (Toggle Plain Text) 
  1. <script language="JavaScript" type="text/JavaScript">
  2. <!--
  3. function uncheckRadio() {
  4.  var choice = document.form1.RadioGroup1;
  5.  for (i = 0; i < choice.length; i++) {
  6.   if ( choice[i].checked = true ) 
  7.    choice[i].checked = false; 
  8.  }
  9. }
  10. //-->
  11.  
  12.  
  13. 	<script language="JavaScript">
  14. function checkRegex(object_value, regex) {
  15. 	return regex.test(object_value);
  16. }
  17.  
  18. function validateform (f) {
  19.  
  20. if (f.Team1.checked == false && f.Team2.checked == false ) {
  21. 	alert("Please select at least one type of service you are interested in.");
  22. 	return false;
  23. } else if (f.Team1.checked == true && f.Team2.checked == true ) {
  24. 	alert("You Must Select only Economy Buster or Lawn Treatment Please un-check one.");
  25. 	return false;
  26. } else if (f.Team1.value == "") {
  27. 	alert("Please enter your first name.");
  28. 	return false;
  29. } else if (f.Team2.value == "") {
  30. 	alert("Please enter your last name.");
  31. 	return false;
  32. }
  33. 	return true;
  34. }
  35.  
  36. function doValidateForm() {
  37. 	if (validateform(document.frmTeam)) document.frmTeam.submit();
  38. }
  39.  
  40.  
  41. </script>
  42.  
  43. <cfquery name="Get_members" datasource="#application.dsn#">
  44. SELECT * FROM members
  45. </cfquery>
  46.  
  47.  
  48. 	<table cellspacing="0" cellpadding="0" border="0" width="523">
  49. 					<cfoutput>
  50. 					<table cellspacing="0" cellpadding="0" border="0">
  51. 					<tr>Name<br></td>
  52. 						<td class="infoBoxShaded">#get_members.first_name# #get_members.last_name#</td>
  53.                     </tr>
  54.                     <tr>
  55. 						<td class="infoBoxShaded">#get_members.address# #get_members.city# #get_members.zip#</td>
  56. 						<td class="infoBoxShaded"><img src="images/spacer.gif" width="20" height="1" alt="" border="0"></td>
  57. 						<td class="infoBoxShaded"></td>
  58. 						<td class="infoBoxShaded" colspan="3"></td>
  59. 					</tr>
  60. 					<tr>
  61. 						<td class="infoBoxShaded">SCORE: #get_members.score#</td>
  62. 						<td class="infoBoxShaded"><br><br>#session.sessionID#</td>
  63. 						<td class="infoBoxShaded" colspan="5"></td>
  64. 					</tr>
  65.  
  66. 					</table>
  67. 					</cfoutput>
  68. </table>
  69. <p>&nbsp;</p>
  70.  
  71. <p><strong>Week 1</strong></p>
  72.  
  73.  
  74.  
  75.  
  76. <tr>
  77.  
  78. </tr>
  79.  
  80.  
  81.  
  82. <cfform action="getEstimate_step2.cfm" method="post" name="frmWon">
  83. <input type="Hidden" name="action" value="continue">
  84. <table border="0" cellpadding="1" cellspacing="0" bordercolor="#000000" width="45%">
  85. <tr>
  86.     <td><div class="content_black">Game</div></td>
  87.     <td><div class="content_black">Week</div></td>
  88. 	<td><div class="content_black">Home Team</div></td>
  89. 	<td><div class="content_black">Away</div></td>
  90.  
  91.                <cfquery name="Picks" datasource="#application.dsn#">
  92.                 SELECT distinct Games.game, games.week, games.home_team, games.away_team FROM Games
  93.                 where games.week = '1'
  94.  
  95.  
  96.                </cfquery>
  97.  
  98. </tr>
  99. <cfloop query="Picks">
  100. <cfoutput>
  101. <tr>
  102. 	<td><div class="content_black">Game #Game#&nbsp;</td>
  103. 	<td><div class="content_black">Week #Week#&nbsp;</td>
  104. 	<td><div class="content_black"><cfinput type="radio" name="mainloop" value="1" required="yes" message="Please select the right option">#Home_team#&nbsp;</td>
  105. 	<td><div class="content_black"><cfinput type="radio" name="mainloop" value="0" required="yes" message="Please select the right option">#Away_team#&nbsp;</td>
  106.  
  107. </tr>
  108. </cfoutput>
  109. </cfloop>
  110. <INPUT type="submit" name="mysubmit" value="Submit">
  111. </cfform>
  112. </table>
http://Vortexamerica.com
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 596
Reputation: buddylee17 has a spectacular aura about buddylee17 has a spectacular aura about 
Solved Threads: 125
buddylee17's Avatar
buddylee17 buddylee17 is offline Offline
Posting Pro

Re: Radio button problem and cfloop

 
0
  #2
Sep 11th, 2009
Right now you only have 1 radio group with only 1 possible value. Split them up by renaming from mainloop to mainloopH and mainloopA like below:
coldfusion Syntax (Toggle Plain Text) 
  1.  
  2. <td><div class="content_black"><cfinput type="radio" name="mainloopH" value="1" required="yes" message="Please select the right option">#Home_team#&nbsp;</td>
  3.  
  4. <td><div class="content_black"><cfinput type="radio" name="mainloopA" value="0" required="yes" message="Please select the right option">#Away_team#&nbsp;</td>
Lost time is never found again.
- Benjamin Franklin
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 337
Reputation: freshfitz is an unknown quantity at this point 
Solved Threads: 27
freshfitz freshfitz is offline Offline
Posting Whiz

Re: Radio button problem and cfloop

 
0
  #3
Sep 12th, 2009
No didn't work http://67.219.102.67/wcfootball/index2.cfm I need them to be able to select 1 team from game 1 1 team from game 2 1 team from game 3 and so on.
http://Vortexamerica.com
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 596
Reputation: buddylee17 has a spectacular aura about buddylee17 has a spectacular aura about 
Solved Threads: 125
buddylee17's Avatar
buddylee17 buddylee17 is offline Offline
Posting Pro

Re: Radio button problem and cfloop

 
0
  #4
Sep 14th, 2009
Then you'll need one unique name for each group of radio buttons (each game):
coldfusion Syntax (Toggle Plain Text) 
  1. <cfset i = 1>
  2. <cfloop query="Picks">
  3. <cfoutput>
  4. <tr>
  5. 	<td><div class="content_black">Game #Game#&nbsp;</td>
  6. 	<td><div class="content_black">Week #Week#&nbsp;</td>
  7. 	<td><div class="content_black"><cfinput type="radio" name="mainloopGame#i#" value="1" required="yes" message="Please select the right option">#Home_team#&nbsp;</td>
  8. 	<td><div class="content_black"><cfinput type="radio" name="mainloopGame#i#" value="0" required="yes" message="Please select the right option">#Away_team#&nbsp;</td> 
  9. </tr>
  10. <cfset i = i + 1> 
  11. </cfoutput>
  12. </cfloop>
You should also consider cleaning up your html. You have several div tags that aren't closed.
Last edited by buddylee17; Sep 14th, 2009 at 6:52 pm.
Lost time is never found again.
- Benjamin Franklin
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 337
Reputation: freshfitz is an unknown quantity at this point 
Solved Threads: 27
freshfitz freshfitz is offline Offline
Posting Whiz

Re: Radio button problem and cfloop

 
0
  #5
Sep 14th, 2009
OH the first option did work sorry

ColdFusion Syntax (Toggle Plain Text) 
  1.  <cfquery name="Games" datasource="#application.dsn#">
  2.                 SELECT * FROM Games
  3.                </cfquery>
  4.  
  5. </tr>
  6.  
  7. <tr>
  8.     <td><div class="content_black">Game 1&nbsp;</td>
  9. 	<td><div class="content_black">Week 1&nbsp;</td>
  10.  
  11. 	<td><div class="content_black">  <input name="RadioGroup"  type="radio" value="1" ondblclick="uncheckRadio();">Tenessee Titans&nbsp;</td>
  12. 	<td><div class="content_black">  <input name="RadioGroup"  type="radio" value="0" ondblclick="uncheckRadio();">Pittsburgh Steelers&nbsp;</td>
  13.  
  14. </tr>
  15. <tr>
  16.     <td><div class="content_black">Game 2&nbsp;</td>
  17. 	<td><div class="content_black">Week 1&nbsp;</td>
  18.  
  19. 	<td><div class="content_black"><input type="radio" name="RadioGroup1" value="1" required="yes" message="Please select the right option">Miami Dolphins&nbsp;;</td>
  20. 	<td><div class="content_black"><input type="radio" name="RadioGroup1" value="0" required="yes" message="Please select the right option">Atlanta Falcons&nbsp;</td>
  21.  
  22. </tr><tr>
  23.     <td><div class="content_black">Game 3&nbsp;</td>
  24. 	<td><div class="content_black">Week 1&nbsp;</td>
  25.  
  26. 	<td><div class="content_black"><input type="radio" name="RadioGroup2" value="1" required="yes" message="Please select the right option">Kansas City Chiefs&nbsp;</td>
  27. 	<td><div class="content_black"><input type="radio" name="RadioGroup2" value="0" required="yes" message="Please select the right option">Baltimore Ravens&nbsp;</td>
  28.  
  29. </tr><tr>
  30.     <td><div class="content_black">Game 4&nbsp;</td>
  31. 	<td><div class="content_black">Week 1&nbsp;</td>
  32.  
  33. 	<td><div class="content_black"><input type="radio" name="RadioGroup3" value="1" required="yes" message="Please select the right option">Philadelphia Eagles&nbsp;</td>
  34. 	<td><div class="content_black"><input type="radio" name="RadioGroup3" value="0" required="yes" message="Please select the right option">Carolina Panthers&nbsp;</td>
  35.  
  36. </tr><tr>
  37.     <td><div class="content_black">Game 5&nbsp;</td>
  38. 	<td><div class="content_black">Week 1&nbsp;</td>
  39.  
  40. 	<td><div class="content_black"><input type="radio" name="RadioGroup4" value="1" required="yes" message="Please select the right option">Denver Broncos&nbsp;</td>
  41. 	<td><div class="content_black"><input type="radio" name="RadioGroup4" value="0" required="yes" message="Please select the right option">Cincinnati Bengals&nbsp;</td>
  42.  
  43. </tr><tr>
  44.     <td><div class="content_black">Game 6&nbsp;</td>
  45. 	<td><div class="content_black">Week 1&nbsp;</td>
  46.  
  47. 	<td><div class="content_black"><input type="radio" name="RadioGroup5" value="1" required="yes" message="Please select the right option">Minnesota Vikings&nbsp;</td>
  48. 	<td><div class="content_black"><input type="radio" name="RadioGroup5" value="0" required="yes" message="Please select the right option">Cleveland Browns&nbsp;</td>
  49.  
  50. </tr>
  51. <center><br><input type="submit" />
  52. </form>
  53.  
  54.  
  55.  
  56. <tr>
  57.  
  58. </tr>
  59.  
  60. </table>
  61.  
  62. </cfif>
Last edited by freshfitz; Sep 14th, 2009 at 8:34 pm.
http://Vortexamerica.com
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ColdFusion Forum
Thread Tools Search this Thread



adobe adobelivecyclees alfresco amazon cfquery checkbox coldfusion contentmanagement dreamweaver ebooks insert kindle multiple opensource openstandards pdf select sony sonyreader
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC