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

Key: FC-1448
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Frank Brea
Reporter: Frank Brea
Votes: 0
Watchers: 0
Operations

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

oracle compatibility for farcry updater 4 > 5

Created: 12/Aug/08 04:48 PM   Updated: 13/Aug/08 11:30 AM
Component/s: None
Affects Version/s: None
Fix Version/s: 5.0.2

Time Tracking:
Not Specified


 Description  « Hide
added oracle case for updating application typeNames createdBy field in farcry 4 to farcry 5 updater

line 335 insert

<cfcase value="ora">
<!--- Update profiles --->
<cfquery datasource="#application.dsn#">
UPDATE #typename# t
SET t.#property# = (
SELECT u.username || '_' || u.userDirectory
FROM dmProfile u
WHERE to_char(t.#property#) = to_char(u.username)
)
WHERE EXISTS (
SELECT u.username || '_' || u.userDirectory
FROM dmProfile u
WHERE to_char(t.#property#) = to_char(u.username)
)
</cfquery>
</cfcase>

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Frank Brea - 12/Aug/08 04:50 PM
update committed to 5.0.1