Binding and cfquery output

[Ronsweb]

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

[Ronsweb · Accepted solution]

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>