Re: CFGrid Can't get value if data type is in

["BKBK" <webforumsuser@xxxxxxxxxxxxxx>]

It seems like all you want to do is bind the grid values to the form. If so, 
then simply use the bind attribute, as follows:



 <cfquery name="qsrec_fee" datasource="#request.dsn#">
 SELECT seq+' ' AS seq ,*
 FROM Rec_fee
 </cfquery>
 <cfform format="flash" width="700">
 <cfformgroup type="panel" label="?????????????">
 <cfgrid name="contactList" query="qsrec_fee" rowheaders="false" height="225" >
 <cfgridcolumn name="seq" header="???????????????">
 <cfgridcolumn name="fee_type_id" header="?????????????"> 
 <cfgridcolumn name="fee_name_th" header="????????????????????">
 <cfgridcolumn name="fee_name_en" header="???????????????????????">
 <cfgridcolumn name="calculate_type_id" header="?????????"> 
 </cfgrid>
 <cfinput type="button" name="fnew" value="?????" onClick="#scnew#">
 </cfformgroup>
 <cfformgroup type="panel">
 <cfinput type="text" name="ffee_name_th" label="?????????????????" 
bind="{contactList.selectedItem.fee_name_th}"  width="100" required="yes">
 <cfinput type="text" name="ffee_name_en" label="????????????????????" 
bind="{contactList.selectedItem.fee_name_en}"  width="100">
 <cfinput type="text" name="fseq" label="???????????????????"  
bind="{contactList.selectedItem.seq}" width="200" required="yes">
 <cfinput type="checkbox" name="fca1" label="????????????????????">
 <cfinput type="checkbox" name="fca2" label="???????????????????????????">
 <cfinput type="checkbox" name="fca3" label="?????????????????????????">
 <cfinput type="text" name="ffee_type_id" 
bind="{contactList.selectedItem.fee_type_id}">
 </cfformgroup>
 </cfform>