I think this one is a double quote single quote thingy...........
Why doesn't the decrypt work in the query? - it works when I set the a
variable......
<cfset a=decrypt(#session.UserName#, #application.key#)>
<cfoutput>
#a#
</cfoutput>
<cfif isdefined("session.loggedin")>
<CFQUERY NAME="alldata"
DATASOURCE="SecureDSN"
username = 'decrypt(#session.UserName#,
#application.key#)'
password = 'decrypt(#session.password#,
#application.key#)'>
SELECT *
FROM Test
WHERE 0=0
</CFQUERY>
<cfoutput query="alldata">
#Name#
#Address#
</cfoutput>
<cfelse>
<cfoutput>
Before you can access this data you need to <a href
="loggedin/password.cfm" target="_top">login</a>
</cfoutput>
</cfif>
*************************************************************************************************
The information contained within this e-mail sent by Birmingham City Council is
confidential and is intended for the named recipient only. If you are not the intended
recipient please notify us by telephone immediately on +(44) 121 303 6666
(International) or return it to us by e-mail quoting the name of the sender and the
addressee.
*************************************************************************************************
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]