
|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
1.
farLog.cfc (18 kb)
|
|
Environment:
|
Oracle 8i, CFMX 7, Shared Host
|
|
|
There were two problems with the farLog.cfc file, which I am attaching as a reference. The first was in the function "getTypeEventList", where the SQL query used characters illegal in Oracle (the concatenation shorthand '+'). Instead, I changed the function to use CONCAT(), which can only take two values in Oracle. However, there is an identical function in MySQL that should work.
The second problem was in the getUserActivityDaily function. There was a table name under the oracle section "farLogin" instead of the correct "farLog".
|
|
Description
|
There were two problems with the farLog.cfc file, which I am attaching as a reference. The first was in the function "getTypeEventList", where the SQL query used characters illegal in Oracle (the concatenation shorthand '+'). Instead, I changed the function to use CONCAT(), which can only take two values in Oracle. However, there is an identical function in MySQL that should work.
The second problem was in the getUserActivityDaily function. There was a table name under the oracle section "farLogin" instead of the correct "farLog". |
Show » |
|