CFDJ Vol. 3 , Issue 2 - pg.45
Ask The Training Staff, by Bruce Van Horn 

Listing 1


List.cfm


<CFQUERY NAME="qGetBeans" DATASOURCE="FastTrack_Solution">
       SELECT * FROM Beans
       ORDER BY  Bean_ID
</CFQUERY>


<CFOUTPUT QUERY="qGetBeans">
<AHREF="details.cfm?ID=#URLEncodedFormat(Encrypt(qGetBeans.Bean_ID,"key"))#">
#qGetBeans.Bean_Name#</A><BR>
</CFOUTPUT>


Listing 2


Details.cfm


<CFQUERY NAME="qGetBeans" DATASOURCE="FastTrack_Solution">
       SELECT * FROM Beans
       WHERE Bean_ID = #Decrypt(URL.ID,"key")#
</CFQUERY>