CFGrid Can't get value if data type is in

[phunsanit]

my cfgride can't return data if buill form integer field
After upgrade form 7.0 to coldfusion 8
(i use ms sql server)


************************************************** ******************************
************************************************** *****
<cfsavecontent variable="scdisplay">
ffee_type_id.text = contactList.selectedItem.fee_type_id;
ffee_name_th.text = contactList.selectedItem.fee_name_th;
ffee_name_en.text = contactList.selectedItem.fee_name_en;
fseq.text = contactList.selectedItem.seq;
</cfsavecontent>
<!---<cfquery name="qsrec_fee" datasource="#request.dsn#">
SELECT seq+' ' AS seq ,*
FROM Rec_fee
</cfquery>--->
<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"
onchange="#scdisplay#">
<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="?????????????????" width="100"
required="yes">
<cfinput type="text" name="ffee_name_en" label="????????????????????"
width="100">
<cfinput type="text" name="fseq" label="???????????????????" 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">
</cfformgroup>
</cfform>

[BKBK]

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>