Help with script to select and deselect form inputs

ColdFusion 9
MS SQL Server 2005
Javascript

Hi. I need some help with a script.

In brief: In a form, when I select a radio button, then I want to deselect anything that was previously selected in the form's select menu.

Details:

* I have an edit form that allows the user to make a web page into a Parent page or a Child page.

* The edit form has a select menu in which the user chooses a Parent page -- this makes the page a Child page, with the selected Parent in the select menu. See attached image.

* My trouble is, when I select a Parent page for a Child page (from the Select menu), and then change my mind and want to make the Child page into a Parent page, the Selected Parent page stays selected. It should not stay selected.

* So, when the radio buttons "Make this page a Parent page" or "Make this page a Floating Page are selected, then the Select menu should be cleared / deselected. This is the crux of the problem.

* As you can see in the attached image, the Select menu does not get cleared when a radio button is selected.

* So when I update the page, ColdFusion does not know what to do.

I believe I need to change this script, below, to enforce the rule above.

What do you think? I am not sure where to begin or how to usefully edit the script, below. Thank you for any advice!

Eric

Script (I think this needs to change somehow; I am not sure how; nor am I certain of this):

<script language="javascript" type="text/javascript">

$(document).ready(function() {
	$("form").submit(function(e) {
		var IndexSelected = $("select[name='ParentID']").prop("selectedIndex") != -1;
		var RBChecked = $("input[type='radio'][name='ParentID']:checked").length > 0;
		
	if( (!IndexSelected && !RBChecked) || (IndexSelected && RBChecked ) ) {
		e.prLinkDefault();
		
		alert("Please select a navigation option: make this page a parent page or a child page, or exclude the page from navigation.");
		                }                
						})                
	$("select[name='ParentID']").change(function() {
	if($("select[name='ParentID']").prop("selectedIndex") != -1) {
		$("input[type='radio'][name='ParentID']").attr("checked",false);
						}
						});
	$("input[type='radio'][name='ParentID']").change(function() {
	if( $("input[type='radio'][name='ParentID']:checked").length > 0 ) {
		$("select[name='ParentID']").prop("selectedIndex", -1);
						}
						});
						})
</script>

Select allOpen in new window

Query to update ParentID forweb page records (I don't think this needs to change, but including it anyway for completion):

<!--- query UpdatePage updates a page record in web site content table --->
            <cfquery name="UpdatePage" datasource="#application.datasource#">
				  UPDATE #REQUEST.contentTable#
				  SET
           PageTitle = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Trim(Left(form.PageTitle,255))#">,   
           buddha_main = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Trim(form.buddha_main)#">,
           DateModified = <cfqueryparam cfsqltype="cf_sql_timestamp" value="#now()#">,
           ParentID = <cfqueryparam cfsqltype="cf_sql_integer" value="#form.parentID#" null="#form.parentID eq -1#">,
           SortOrder = <cfqueryparam cfsqltype="cf_sql_integer" value="#val(form.SortOrder)#">,
           safeURL = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Trim(Left(form.safeURL,255))#">
           WHERE PageID = <cfqueryparam cfsqltype="cf_sql_integer" value="#val(form.PageID)#">
			</cfquery>

Select allOpen in new window

         
           
           
Form fields (I don't think this needs to change, but including it anyway for completion):

1. You may make this page a "Parent" page in the main navigation menu.
<cfinput type="radio" value="0" name="ParentID" checked="#editPage.ParentID eq 0#" />

2. Or you may make this page a child page; choose a parent page under which this page should appear in the navigation menu. Choose parent page from the Select menu:

<!--- query to get grandchild pages, so we can OMIT them from SELECT MENU --->
<!--- grandchild pages do not get to be parents of child pages --->
<cfquery name="GetParents" datasource="#application.datasource#">
    SELECT        base.PageID  
                 ,base.PageTitle 
                 ,base.SortOrder 
                 ,base.ParentID  
     
FROM #REQUEST.contentTable# base
            LEFT JOIN #REQUEST.contentTable# p ON p.pageID = base.parentID   <!--- find parent --->
            LEFT JOIN #REQUEST.contentTable# gc ON gc.pageID = p.parentID      <!--- find grandchild ---> 
WHERE gc.PageID IS NULL
AND     base.PageID <>  <cfqueryparam cfsqltype="cf_sql_integer" value="#val(form.PageID)#">
AND     base.ParentID <>  <cfqueryparam cfsqltype="cf_sql_integer" value="100000">           
</cfquery>
    
  
<!--- query getSelectedParents gets ParentID of Parent page that is selected in the form  --->
  <cfquery datasource="#application.datasource#" name="getSelectedParents">
        SELECT  PageTitle, ParentID
        FROM    #REQUEST.contentTable#
        WHERE ParentID = <cfqueryparam cfsqltype="cf_sql_integer" value="#val(form.ParentID)#">
</cfquery>

<cfset selectedParents = valueList(getSelectedParents.ParentID)>
  
  <!--- use this select menu to display and assign parent page Titles --->
  <!--- user should see a human-readable list of parent page titles --->
	  	<cfselect size="8" name="ParentID" value="PageID" display="PageTitle" multiple="no" query="GetParents" queryPosition="below" selected="#selectedParents#" id="ParentID" style="width:250px;">
      
    	</cfselect>                
  <!--- when form is processed, the correct ParentID is populated into content table --->
  <!--- ParentID value 0 means the record / web page is a Parent page included in top-level, main navigation menu --->
  <!--- ParentID value 100000 means the record / web page is EXCLUDED from navigation menu, and is a Floating Page --->

3. Or you may exclude this page from navigation. This page becomes a floating page.

<cfinput type="radio" value="100000" name="ParentID" checked="#editPage.ParentID eq 100000#" />
Exclude this page from the navigation menu.

Select allOpen in new window

selectMenu.jpg