I found that if I decouple the encrypt_column from the insert script by
requesting it from dual first, that it then works fine. While I would prefer
to do it without a two-step process, this works fine for now.
<cfquery name="qInsertF9099AlienInfo_prep"
datasource="#application.dbDataSource#">
select Encrypt_Column(RPAD(UPPER(NVL(<cfqueryparam
cfsqltype="cf_sql_varchar" value="#arguments.inStruct.a_alien_last_name#">,'
')),56,' '),'CFASJAAAEPTSKEJPI') as a_alien_ln
from dual
</cfquery>
<cfquery name="qInsertF9099AlienInfo" datasource="#application.dbDataSource#">
INSERT INTO F9099_ALIEN_INFO (
F9099_id, alien_last_name
)
VALUES (
<cfqueryparam cfsqltype="cf_sql_INTEGER"
value="#arguments.inStruct.l_F9099_id#">,
<cfqueryparam cfsqltype="CF_SQL_VARBINARY"
value="#qInsertF9099AlienInfo_prep.a_alien_ln#">
)
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358707
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
