Bind in form works with cfinput, how to with cfselect and a href

goodychurro1 wrote: [...] this href doesn't seem to bind correctly: [...] This cfselect doesn't either: [...] How can I make them both work? Thank you

Hi goodychurro1,

The tag you're looking for is cfajaxproxy.  Here is a example to get you started (if you're on CF9, just remove the 3rd attribute from the queryNew() and then populate the query using a queryAddRow() and three querySetCell()s):

<cfset q = queryNew("myID,myString", "integer,varchar", [[1,"one"],[2,"two"],[3,"three"]]) />

<cfajaxproxy bind="javascript:myHandler({myGrid.myID})" />

<script type="text/javascript">

  function myHandler(myID) {

      //update the link's href

      document.getElementById('myLink').href = 'http://www.coldfusion.com?q=' + myID;

      //update the select's selected

      var theField = document.getElementById('mySelect');

      for(var i=0; i<theField.options.length; i++) {

          if(theField.options.value==myID) {

              theField.options.selected = true;

          } else {

              theField.options.selected = false;

          }

      }

  }

</script>

<cfform>

  <cfgrid name="myGrid" format="html" width="200" query="q">

    <cfgridcolumn name="myID" />

    <cfgridcolumn name="myString" />

  </cfgrid>

  <cfselect name="mySelect" query="q" display="myString" value="myID" />

</cfform>

<a href="" id="myLink" target="_blank">text</a>

Selecting a row in the grid changes the link's href and the select's selected option.

References:

- cfaxaxproxy

- Binding data to form fields

- a blog post that might be of help

Thanks,

-Aaron