thanks for the reply claude how would i get around the issue of encypting data in integer columns? - as some of the columns are set as smallint(2) for example.
just thinking of the top of my head: when a user chooses to encrypt a column of data, the code could create a replica column which is varchar(255) and places all encrypted data in that column and removes it from the original column. if they choose to decrypt it then it puts all decrypted data back into the original column. what do you think? thanks >>>1) seeing as this can be run on any column (even integer fields) is >it possible to encrypt an integer and then place the resulting encrypted >string back into the integer column of the database > >If the encrypted data is also an integer, then yes, but if is can be any >string, forget it. Not even woth trying. > > >>2) as this function will run on any table/column how can i write an >sql statement that just loops through the column encrypting the data? >This depends on the database you're using. May be a stored procedure >could do it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
