I am desperate. cfgrid populate problem

[ayhanyildiz]

I am preparing some intranet application. I want to hide customers CCnumber
and list only last 4 digit. But I don't want this in input text. I just want to
display as a simple text outside of input box. I am using cfgrid to populate
data into form. if you had experienced, please let me know how to do it. Thanks

[OldCFer]

Use:
<cfoutput> .......#Right(CCNumber,4)#</cfoutput>

[ayhanyildiz]

Larry,Thanks for the answer but it is not the answer. I am populating data with cfgrid. I am binding data to form fields but I can not bind anything (or with your approach; output) but form fiels.

[Rodney Olivier]

<cfform ....>
<cfgrid ... don't set query here But do set other cfgrid parameters.>
<CFLOOP query="queryname">
<cfgridrow data="#FIELDNAME# ,#RIGHT(CCNUMBER,4)# ''>
<CFLOOP>
<CFGRIDCOLUMN name="FIELDNAME" >
<CFGRIDCOLUMN name="CCNUMBER">
</cfform>
NOTE sometimes a space between the FIELD/FUNCTION( ) and the next comma is
needed on the CFGRIDROW line...
IE =<cfgridrow data="#FIELDNAME#[space goes here],#RIGHT(CCNUMBER,4)#[space
goes here]''>

[QueTwo]

Originally posted by: ayhanyildiz
I am preparing some intranet application. I want to hide customers CCnumber
and list only last 4 digit. But I don't want this in input text. I just want to
display as a simple text outside of input box. I am using cfgrid to populate
data into form. if you had experienced, please let me know how to do it. Thanks

Use the following :

...
<CFGRIDCOLUMN name="CCnumber" Mask="XXXX-XXX-XXXX-9999" DISPLAY="No">
....

<CFFORMITEM type="text" bind="{myGrid.SelectedItem.CCnumber}">

Hope that helps.

-Nick Kwiatkowski
Hostingplace.NET Sr. Application Developer

[ayhanyildiz]

Thanks for the help Rodney Olivier and Nick Kwiatkowski.
Nick your solution is right one for my application. Thanks a lot for the help.