
| Key: |
FC-1448
|
| Type: |
Improvement
|
| Status: |
Closed
|
| Resolution: |
Fixed
|
| Priority: |
Major
|
| Assignee: |
Frank Brea
|
| Reporter: |
Frank Brea
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
|
| Component/s: |
None
|
| Affects Version/s: |
None
|
| Fix Version/s: |
5.0.2
|
|
|
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>
|
|
Description
|
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> |
Show » |
|