I have been staring at this problem for the entire day now and I still can't figure it out. I think it is a simple solution but I got nothing. What I am trying to do is pass the value (Yes/No) of two seperate radio groups (FORM.MSEL_Delete, FORM.Input_Delete) on through the url to a new page when the form is submitted. The problem is the url always shows the answer as being "No". Any suggestions?
Thanks
here is my code:
<cfparam name="FORM.Exercise_Name" default="">
<cfparam name="FORM.MSEL_Delete" default="">
<cfparam name="FORM.Input_Delete" default="">
<cfparam name="FORM.MM_DeleteRecord" default="">
<cfif IsDefined("url.Current_Exercise_ID") AND #url.Current_Exercise_ID# NEQ "">
<cfquery name="Get_Exercise_Info" datasource="ExerciseWA">
SELECT * From Current_Exercises
WHERE Current_Exercise_ID = #url.Current_Exercise_ID#
</cfquery>
<cfelse>
<cfquery name="Get_Exercise_Info" datasource="ExerciseWA">
SELECT * From Current_Exercises
WHERE Exercise_Name = '#FORM.Exercise_Name#'
</cfquery>
</cfif>
<div align="center"><font color="#000066"><strong>Delete Exercise</strong></font></div>
<form name="Delete_Exercise_Form" method="post" action="./Delete_Temp.cfm?Current_Exercise_ID=
<cfoutput>#Get_Exercise_Info.Current_Exercise_ID#</cfoutput>
&Delete_MSEL=<cfif #FORM.MSEL_Delete# EQ "Yes">Yes<cfelse>No</cfif>
&Delete_Inputs=<cfif #FORM.Input_Delete# EQ "No">Yes<cfelse>No</cfif>">
<div align="center">
<table width="0" border="0" cellspacing="2" cellpadding="0">
<tr>
<td colspan="2"> <div align="center">
<label>Exercise Name: </label>
<input name="Exercise_Name" type="text" value="<cfif isdefined("Get_Exercise_Info.Exercise_Name")
AND #Get_Exercise_Info.Exercise_Name# NEQ ""><cfoutput>#Get_Exercise_Info.Exercise_Name#</cfoutput>
<cfelse></cfif>" size="25">
</div></td>
</tr>
<tr>
<td width="300"><div align="right">Delete MSEL and all Injects?</div></td>
<td width="300">
<input type="radio" name="MSEL_Delete" value='Yes'>
<label>Yes</label>
<input type="radio" name="MSEL_Delete" value='No' checked>
<label>No</label>
</td>
</tr>
<tr>
<td width="300"><div align="right">Delete Exercise Inputs, Attritions, and Outstanding Performers?</div></td>
<td width="300">
<input type="radio" name="Input_Delete" value='Yes'>
<label>Yes</label>
<input type="radio" name="Input_Delete" value='No' checked>
<label>No</label>
</td>
</tr>
</table>
<input name="Delete_Exercise" type="submit" value="Delete">
<input name="MM_DeleteRecord" type="hidden" value="Delete_Exercise_Form">
<br>
<font color="#FF0000"><strong>Please be sure you want to permanently delete the above items!!!
Once deleted they will not be recoverable!!!</strong></font>
</div>
</form>
Thanks
here is my code:
<cfparam name="FORM.Exercise_Name" default="">
<cfparam name="FORM.MSEL_Delete" default="">
<cfparam name="FORM.Input_Delete" default="">
<cfparam name="FORM.MM_DeleteRecord" default="">
<cfif IsDefined("url.Current_Exercise_ID") AND #url.Current_Exercise_ID# NEQ "">
<cfquery name="Get_Exercise_Info" datasource="ExerciseWA">
SELECT * From Current_Exercises
WHERE Current_Exercise_ID = #url.Current_Exercise_ID#
</cfquery>
<cfelse>
<cfquery name="Get_Exercise_Info" datasource="ExerciseWA">
SELECT * From Current_Exercises
WHERE Exercise_Name = '#FORM.Exercise_Name#'
</cfquery>
</cfif>
<div align="center"><font color="#000066"><strong>Delete Exercise</strong></font></div>
<form name="Delete_Exercise_Form" method="post" action="./Delete_Temp.cfm?Current_Exercise_ID=
<cfoutput>#Get_Exercise_Info.Current_Exercise_ID#</cfoutput>
&Delete_MSEL=<cfif #FORM.MSEL_Delete# EQ "Yes">Yes<cfelse>No</cfif>
&Delete_Inputs=<cfif #FORM.Input_Delete# EQ "No">Yes<cfelse>No</cfif>">
<div align="center">
<table width="0" border="0" cellspacing="2" cellpadding="0">
<tr>
<td colspan="2"> <div align="center">
<label>Exercise Name: </label>
<input name="Exercise_Name" type="text" value="<cfif isdefined("Get_Exercise_Info.Exercise_Name")
AND #Get_Exercise_Info.Exercise_Name# NEQ ""><cfoutput>#Get_Exercise_Info.Exercise_Name#</cfoutput>
<cfelse></cfif>" size="25">
</div></td>
</tr>
<tr>
<td width="300"><div align="right">Delete MSEL and all Injects?</div></td>
<td width="300">
<input type="radio" name="MSEL_Delete" value='Yes'>
<label>Yes</label>
<input type="radio" name="MSEL_Delete" value='No' checked>
<label>No</label>
</td>
</tr>
<tr>
<td width="300"><div align="right">Delete Exercise Inputs, Attritions, and Outstanding Performers?</div></td>
<td width="300">
<input type="radio" name="Input_Delete" value='Yes'>
<label>Yes</label>
<input type="radio" name="Input_Delete" value='No' checked>
<label>No</label>
</td>
</tr>
</table>
<input name="Delete_Exercise" type="submit" value="Delete">
<input name="MM_DeleteRecord" type="hidden" value="Delete_Exercise_Form">
<br>
<font color="#FF0000"><strong>Please be sure you want to permanently delete the above items!!!
Once deleted they will not be recoverable!!!</strong></font>
</div>
</form>