Another bind question

WolfShade wrote: ... I'm trying to bind the select to a javascript function that will validate the dates - if everything is in order, call the CFC that populates the changing select; otherwise, throw an alert and prevent the event. So the function is running the SQL statement and returning results, but I just realized that I don't know how to repopulate the options in the one select without reloading the page.  Is there a way to have the options regenerated from JavaScript without reloading the page?

You could use cfajaxproxy to create a Javascript proxy of the CFC on the client browser. The documentation on the cfajaxproxy tag offers you a fully worked out example.

You could then add validation code at the beginning of the asynchronous call to populate the select list. I modified the example in the documentation, using my own customer.cfc in place of employee.cfc, thus

<cfajaxproxy cfc="myCFCs.customer" jsclassname="customer">
...

...

          /* Use an asynchronous call to get customers for the drop-down customer list */
            var getCustomers = function(){

                /******* validation code goes in here *******/

        // create an instance of the proxy
                var c = new customer();
                // Setting a callback handler for the proxy automatically makes
                // the proxy's calls asynchronous.
                c.setCallbackHandler(populateCustomers);
                c.setErrorHandler(myErrorHandler);
                ...
        ...
        etc., etc.
            }
...

...

WolfShade wrote: Is there a way to have the options regenerated from JavaScript without reloading the page?

Of course, in JavaScript the code to READ the value of a form control can generally be reversed to SET a value for the form control.

I.E.

aFormControl.value; //reads
aFormControl.value = "FooBar"; //sets.

There are differences for different types of controls, i.e. text boxes versus selects versus radio etc.  But they are all easily found with your favorite Internet search engine.