History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FC-1467
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Unassigned
Reporter: Tomek Kott
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
FarCry Core Framework

fu.cfc bad sql for oracle

Created: 21/Aug/08 02:13 AM   Updated: 06/Oct/08 05:51 PM
Component/s: Core Types
Affects Version/s: 5.0.2
Fix Version/s: FarCry 5.1

Time Tracking:
Not Specified

File Attachments: 1. File fu.cfc (27 kb)

Environment: shared host, *nix, oracle 8i


 Description  « Hide
INNER JOIN and JOIN are bad queries for Oracle 8i. To be able to use FU with 8i, I changed the syntax on all the queries in the file /core/packages/farcry/fu.cfc to just add another WHERE clause using the two tables.

So far, everything seems to work in 5.0.2 using the attached fu.cfc file.

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Tomek Kott - 21/Aug/08 02:14 AM
fu.cfc file which has updated sql syntax.

Matthew Bryant - 06/Oct/08 05:51 PM
Thanks Tomek for your changes.