Keep in mind that a column rename is very expensive and I believe it changes
the underlying dbid of that column (which can cause schema caching issues).
What's going on under the hood is:
Add new column
copy column data
Delete old column
....plus any indexing or FK stuff needed.
-Mark
-----Original Message-----
From: Tony Bentley [mailto:[email protected]]
Sent: Friday, April 03, 2009 3:11 PM
To: cf-talk
Subject: Re: encrypt database column
You can change the name of a column in TQL. In MSSQL there is a stored proc
called sp_rename that would do it. For getting all fields from a column in a
table, that is simply select colname from tablename.
If you wanted to pass the encryptes string into the db, not sure that MSSQL
or MYSQL can do. Why not use CF to process the encrypetd name and pass that
in using cfprocparam in a cfstoredproc tag?
Maybe I am missing the complexity of your objective.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:321303
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
