Setting/Unsetting checkboxes 1

davejoyce · Jun 26, 2000

I am trying to set and unset a value in a database based on the value of a field the user has checked. I am able to set the field in the database but when the user unchecks, the field in the database remains the same. Any Ideas?? Attached is code snippet. ----  personnel4.cfm  ----- <CFIF IsDefined("ID&quot

> <CFSET NewRecord="No">    <CFELSE>     <CFSET NewRecord="Yes"> </cfif> <CFIF NewRecord> <CFSET PageTitle = "Add Personnel"> <CFSET ButtonText = "Add Personnel"> <CFSET Last_Name = ""> <CFSET BroadcastNotify = ""> <CFELSE>  <CFQUERY DATASOURCE="AFSMtest_Sites" Name="Personnel"> SELECT  ID, Last_Name , BroadcastNotify FROM personel_tbl WHERE ID=#ID# </cfquery> <CFSET PageTitle= "Update Personnel-" > <CFSET ButtonText = "Update Personnel"> <CFSET Last_Name = Trim(Personnel.Last_Name)> <CFSET First_Name = Trim(Personnel.First_Name)> <CFSET BroadcastNotify = Personnel.BroadcastNotify> </cfif> <CFOUTPUT> <html> <head> <title>#PageTitle#</title> </head> <body bgcolor="gray"> <H3>#PageTitle#</h3> <FORM ACTION="personnel5.cfm" METHOD="POST"> <CFIF NewRecord IS "No">  <INPUT TYPE="hidden" NAME="ID" VALUE="#ID#"> </cfif> <TABLE BORDER=0 WIDTH=100%> <TR><TD align="right" WIDTH=30%>Last_Name:</td><TD align="Left" WIDTH=70%><INPUT TYPE="text" Name="Last_Name" Size="50" MAXLENGTH="50" VALUE="#Last_Name#"></td></tr> <tr><TD align="right" WIDTH=30%> <CFIF #Compare(#BroadcastNotify#,"1&quot

#> <INPUT TYPE="checkbox" NAME="BroadcastNotify" VALUE="1"> <cfelse> <INPUT TYPE="checkbox" checked NAME="BroadcastNotify" VALUE="1"> <CFSET #BroadcastNotify# = "0"> </cfif> </td><TD align="Left" WIDTH=70%>Notify on Broadcast Message Change? </td></tr> </table> <INPUT TYPE="submit" Value="#ButtonText#"> <INPUT TYPE="reset" VALUE="Clear"> </form> </body> </html> </cfoutput> ---- personnel5.cfm ---- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <CFIF IsDefined("FORM.ID&quot

> <CFUPDATE DATASOURCE="AFSMtest_Sites" TABLENAME="Personel_tbl">   <CFELSE>    <CFINSERT DATASOURCE="AFSMtest_Sites" TABLENAME="Personel_tbl"> </cfif> thanks,   Dave Joyce

silvioc · Jun 28, 2000

I use a quirk in how form variables are passed once the form is submitted: if a checkbox is unchecked it is not passed as a parameter to the receiving form. So, let's say that my checkbox is called frm_chkYN, with accepted values "Y" ana "N". At hte top of the receiving form I put: <cfparam  name="FORM.frm_chkYN" default="N"> and this takes care of the first part of the problem. After reading the value from the database I have a variable set with the value found in the table <cfset VARIABLES.init_chkYN = #QueryName.chkYN#> and in the form itself <cfif VARIABLES.init_chkYN IS "S">     <cfset tChecked="checked"> <cfelse>     <cfset tChecked=""> </cfif> <input type="checkbox"     name="frm_chkYN"     value="Y"     #VARIABLES.tChecked#> Note that the form variable is always set the the checked value HTH

davejoyce · Jun 29, 2000

silvioc, You wrote: "if a checkbox is unchecked it is not passed as a parameter to the receiving form." is this a quirk in coldfusion handling. This isn't something you do?  Your solution worked great. The only thing I don't understand is I don't send the form variable to the receiving form, so I expected the default of N to be picked up always. But it does work as you wrote.             Thanks,               Dave Joyce

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Setting/Unsetting checkboxes 1

davejoyce

Programmer

silvioc

Programmer

davejoyce

Programmer

Similar threads

Part and Inventory Search

Sponsor