Another Oracle issue in two files:
farcry_core/tags/security/ui/dmSec_TestPolicySetup.cfm
farcry_core/tags/security/ui/dmSec_TestSecuritySetup.cfm
Both of these files check the odbc with the following code:
<!--- Test the odbc connection works --->
<cfquery name="testODBC" datasource="#stUd[udName].datasource#"
dbtype="ODBC">
SELECT 1;
</cfquery>
This SQL fails in Oracle. I made a very convoluted fix to this problem a
few months ago, but it involved adding keys to the
Application.dmSec.UserDirectory.ClientUD structure in the
project/config/_dmSecUserDirectories.cfm file. Someone (I'm sorry, I
don't remember who) suggested maybe selecting form the Oracle DUAL table
instead. While I haven't implement this solution, this seems to be a
more elegant solution...
--Nathan
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
