I'm tring to display an encrypted number store in sql database I have a key store in my application.cfm. and they number in my database is encrypted. My display code looks like this
<cfloop query="Get_Orders">
<cfoutput>
<tr>
<td><div class="content_black">#Get_Orders.Credit_Card_Type# </div></td>
<cfset key = #application.key#>
<cfset Cardnum = '#Get_Orders.Credit_Card_Number#'>
<cfset CardDec = decrypt(Cardnum, key)>
<td><div class="content_black">#CardDec# </div></td>
<td><div class="content_black">#Get_Orders.Credit_Card_Month# </div></td>
<td><div class="content_black">#Get_Orders.Credit_Card_Year# </div></td>
<td><div class="content_black">#Get_Orders.Credit_Card_Name# </div></td>
<td><div class="content_black">#Get_Orders.Comments# </div></td>
<td><textarea name="HL_Comments_#Get_Orders.Order_Estimate_ID#" cols="20" rows="5">#Get_Orders.HL_Comments#</textarea></td>
<td align="center"><input type="Checkbox" name="Contacted_#Get_Orders.Order_Estimate_ID#" value="1"<cfif Get_Orders.Contacted IS 1> checked</cfif>></td>
<td><div class="content_black">#Get_Orders.customerNumber#</div></td>
<td><div class="content_black">#Get_Orders.billing_phone#</div></td>
<td><div class="content_black">#Get_Orders.Billing_Email# </div></td>
<td><div class="content_black">#DollarFormat(Get_Orders.invoiceAmt)#</div></td>
<td align="center"><div class="content_black"><input type="Checkbox" name="Processed_#Get_Orders.Order_Estimate_ID#" value="1"<cfif Get_Orders.invoiceProcessed IS 1> checked</cfif>></div></td>
</tr>
</cfoutput>
</cfloop>