Decrypt function and cfgrid

[billy nasty]

Hi,

I want to use the grid together with the decrypt function.
so i have a grid populated from a query. and one column contains a encrypted
value in my db. and i want to see it decrypted in my grid. but i can't seem to
get my variable in the grid.

Any chance you guys could help me out on this one. i searched the internet for
that matter but until now no help.

[Stressed_Simon]

Post the code you have and we shall see. How did you enrypt the data in the first place?

[billy nasty]

to encode my string i do it like this
<cfset ckey = "1a6">
<cfset encryptCCNr = Encrypt(#Form.CCNumber#, ckey)>

so now i want this encrypted value to be decrypted in my cfgrid.
but because my grid is populated with a query.
i cant get a variable in a column.

for decrypting
<cfset ckey = "1a6">
#Decrypt(TravelCards.CCNumber, ckey)#

thanks for the help

greets Billy

[billy nasty]

hi,

i found it out myself. maybe it can be useful to others.

<cfform name="test" action="quer.cfm" format="flash">
<cfgrid name="gried" rowheaders="true" height="300" insert="yes" delete="yes"
insertbutton="Insert" deletebutton="Delete" selectmode="edit" width="400">
<cfgridcolumn name="cc" header="cc" >
<cfgridcolumn name="firma" header="Firma">
<cfgridcolumn name="rid" header="id" display="no">
<cfloop query="ts">
<cfset ckey = "CFMX_COMPAT">
<cfgridrow data="#Decrypt(ts.cc, ckey)#,#ts.firma#,#ts.rid#">
</cfloop>
</cfgrid>
<cfinput type="submit" name="submit" value="submit">
</cfform>