FarCry will not work on Oracle 8i (Oracle 8.1.7.4 on Solaris) due to the
following query which contains the
unsupported 'cross join' - Oracle was sooooo slow in getting support for
Sql-92 standard.
SELECT s.policyGroupId, s.permissionId, b.status FROM
(SELECT g.policyGroupId, p.permissionId FROM farcry.dmPolicyGroup g
CROSS JOIN dmPermission p WHERE
upper(p.PermissionType)='POLICYGROUP' ) s
LEFT
OUTER JOIN farcry.dmPermissionBarnacle b
ON s.permissionId = b.permissionID
AND s.policyGroupId = b.policyGroupId
AND upper(b.Reference1)='POLICYGROUP';
Oracle 8i returns ORA-00907: missing right parenthesis at the 'CROSS'
statement
There are differences between 9i and 8i as Oracle added support for
'left outer joins' in 9i as well as the '(+)' notation. I have not done
any coding for 9i so cant comment on direct syntax fixes or changes.
Brendan at Deamon and I had a lot of problems sorting out which sql
statment that was causing the
problem die to the complex sequence of calls. So to trap the error,
what I did was in cfFunctionWrappers was to modify the 'query' function
by adding a mail out before the sql statment was enacted.
------------------------------------------------------------------------
--------------
<cffunction name="query" hint="a wrappr for cfquery tag for use in
cfscript">
<cfargument name="sql" type="string" required="true">
<cfargument name="dsn" type="string" required="false"
default="#application.dsn#">
<cfmail to="[EMAIL PROTECTED]" from="[EMAIL PROTECTED]" subject="fracry
error">
#now()# #arguments.sql#
</cfmail>
<cfquery name="q" datasource="#arguments.dsn#">
#preserveSingleQuotes(arguments.sql)#
</cfquery>
<!--- This is so we always return a query object - ie update
statements may not return a result --->
<cftry>
<cfif q.recordcount>
<!--- blah --->
</cfif>
<cfcatch>
<cfoutput>#preserveSingleQuotes(arguments.sql)#</cfoutput>
<cfset q = queryNew('acoloumn')>
</cfcatch>
</cftry>
<cfreturn q>
</cffunction>
------------------------------------------------------------------------
------------
so that it would spit at an email every time in ran the 'query'
function. On the CF page, it listed 2 'q' queries but
the email spatout 3, the last one being the one it died on.
and Yes to Paul Hastings, the world had better handle two cf developers
named Dave Watts as I am not going away and besides Tassie is a much
more comfortable place to live than Washington DC. :-)
------------------------------------------------------------------------
-----------------
Dr Dave Watts ph +61 3 62 323 586
Applications/DB Developer fax +61 3 62 323 351
Australian Antarctic Data Centre email [EMAIL PROTECTED]
http://www.aad.gov.au/default.asp?casid=3786
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
