Attached are patches that use the Oracle DUAL table to fix the bug below. I have tested these changes in Oracle and it seems to work fine. (Sorry, I haven't tested against any of the other databases.)
HTH, --Nathan >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf >Of Nathan Mische >Sent: Wednesday, June 16, 2004 1:42 PM >To: FarCry Developers >Subject: [farcry-dev] RE: FarCry version 2.2 beta > > >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/ > >
dmSec_TestPolicySetup.patch
Description: dmSec_TestPolicySetup.patch
dmSec_TestSecuritySetup.patch
Description: dmSec_TestSecuritySetup.patch
--- 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/
