1 Reply Latest reply: Aug 3, 2006 5:14 PM by Ronsweb RSS

    Binding and cfquery output

    Ronsweb Community Member
      Is it possible to display a CF query value in a text field if it has a binding to a datagrid?



      <cfoutput query="qinternalequivalentret">
      <cfformgroup type="vdividedbox" visible="yes" enabled="yes">
      <cfformgroup type="horizontal" visible="yes" enabled="yes">

      <!--- The Value from the cfoutput query will not display because of the datagrid binding --->

      <cfinput type="text" name="catalog_nbr#" width="120" bind="{(data.selectedItem!=undefined)?data.selectedItem.CATALOG_NBR:''}" label="Catalog Number" required="yes" value="#qinternalequivalentret.catalog_nbr#" readonly="true" message="Please enter the catalog number" >
      </cfformgroup>
      </cfformgroup>
      <cfformgroup type="vdividedbox"id="gridpanel" visible="no" enabled="no" height="0">
      <cfformgroup type="horizontal" visible="yes" enabled="yes">
      <cfgrid name= "data" height="200" width="800" onChange="data.visible=false; data.enabled=false;gridpanel.height=0; forInput.text='';" rowheaders="false">
      <cfgridcolumn name="effective_date" header="Course effective date">
      <cfgridcolumn name="equivalency_status" header="Course Status" width="70">
      <cfgridcolumn name="peoplesoft_courseID" header="Course ID" width="65">
      <cfgridcolumn name="subject" header="Subject" width="60">
      <cfgridcolumn name="CATALOG_NBR" header="Catalog Number" width="80">
      <cfgridcolumn name="offer_nbr" header="Offer Nbr" width="60">
      <cfgridcolumn name="units" header="Units" width="50">
      <cfgridcolumn name="course_descr" header="Description" width="150">
      </cfgrid>
      </cfformgroup>
      </cfformgroup>
      </cfoutput>

      The Value from the cfoutput query will not display because of the datagrid binding.

      Thanks in advance,

      Ron
        • 1. Re: Binding and cfquery output
          Ronsweb Community Member
          I figured it out. I removed the binding in the text fields and assigned the values with <cfsavecontent>

          Here is the code:
          <cfsavecontent variable="populatefields">
          this["data_" + #i#].visible=false; this["data_" + #i#].enabled=false;this["gridpanel_" + #i#].height=0; this["forInput_" + #i#].text='';
          this["offer_nbr_" + #i#].text = (this["data_" + #i#].selectedItem!=undefined)?this["data_" + #i#].selectedItem.offer_nbr:'';
          this["lbcc_subject_" + #i#].text = (this["data_" + #i#].selectedItem!=undefined)?this["data_" + #i#].selectedItem.subject:'';
          this["lbcc_catalog_nbr_" + #i#].text = (this["data_" + #i#].selectedItem!=undefined)?this["data_" + #i#].selectedItem.CATALOG_NBR:'';
          this["peoplesoft_courseID_" + #i#].text = (this["data_" + #i#].selectedItem!=undefined)?this["data_" + #i#].selectedItem.peoplesoft_courseID:'';
          this["lbcc_course_name_" + #i#].text = (this["data_" + #i#].selectedItem!=undefined)?this["data_" + #i#].selectedItem.course_descr:'';
          this["lbcc_units_" + #i#].text = (this["data_" + #i#].selectedItem!=undefined)?this["data_" + #i#].selectedItem.units:'';
          </cfsavecontent>

          <cfformgroup type="vdividedbox" visible="yes" enabled="yes">
          <cfformgroup type="horizontal" visible="yes" enabled="yes">
          <cfinput type="hidden" name="offer_nbr_#i#" width="120" value="#qinternalequivalentret.offer_nbr#">
          <cfinput type="text" name="lbcc_subject_#i#" message="Please enter the LBCC subject." width="120" label="Subject" required="yes" readonly="true" value="#qinternalequivalentret.lbcc_subject#" ><cfinput type="text" name="lbcc_catalog_nbr_#i#" width="120" label="Catalog Number" required="yes" value="#qinternalequivalentret.lbcc_catalog_nbr#" readonly="true" message="Please enter the catalog number" ><cfinput type="text" name="peoplesoft_courseID_#i#" message="Please enter a Course ID" width="200" label="Course ID number (e.g. 000115)" required="yes" readonly="true" value="#qinternalequivalentret.peoplesoft_courseID#">
          </cfformgroup>
          </cfformgroup>
          <cfformgroup type="vdividedbox"id="gridpanel_#i#" visible="no" enabled="no" height="0">
          <cfformgroup type="horizontal" visible="yes" enabled="yes">
          <cfgrid name= "data_#i#" height="200" width="800" onChange="#populatefields#" rowheaders="false">
          <cfgridcolumn name="effective_date" header="Course effective date">
          <cfgridcolumn name="equivalency_status" header="Course Status" width="70">
          <cfgridcolumn name="peoplesoft_courseID" header="Course ID" width="65">
          <cfgridcolumn name="subject" header="Subject" width="60">
          <cfgridcolumn name="CATALOG_NBR" header="Catalog Number" width="80">
          <cfgridcolumn name="offer_nbr" header="Offer Nbr" width="60">
          <cfgridcolumn name="units" header="Units" width="50">
          <cfgridcolumn name="course_descr" header="Description" width="150">
          </cfgrid>
          </cfformgroup>
          </cfformgroup>
          <cfformgroup type="vdividedbox" visible="yes" enabled="yes">
          <cfformgroup type="horizontal" visible="yes" enabled="yes">
          <cfinput type="text" name="lbcc_course_name_#i#" value="#qinternalequivalentret.lbcc_course_name#" message="Please enter the Long Beach City College course name." width="300" label="Long Beach City College Course Name (e.g. Macro-Economics)" required="yes" readonly="true">
          <cfinput type="text" name="lbcc_units_#i#" value="#qinternalequivalentret.lbcc_units#" maxlength="3" message="Please enter a Long Beach City College course unit value." width="30" label="Long Beach City College Course Unit value" validate="float" required="yes" readonly="true">
          </cfformgroup>
          </cfformgroup>
          </cfformgroup>