Hi, I have looked around on the web for the answer to this question and haven't yet found exactly the answer i need
basically, we are developing code that dynamically encrypts database columns (depending on what the user wants encrypted). we want to build one function that is responsible for encrypting a database column data. My question is basically in 2 parts: 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 (wouldn't this throw an error). i know i could try this out myself but even if it works i will have no idea why it worked so would like it if someone could point me in the direction to fully understand this... and of course if it does throw an error then how should i look to tackle this? 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? would i need to first run some code that gets the primary keys and then refers to them? i am thinking there must be a way in sql just to loop through each cell in a column instead of having to refer to the primary keys?... i just cannot figure out how to do this! thanks for any help richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:321286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
