| Key: |
FC-666
|
| Type: |
Bug
|
| Status: |
Resolved
|
| Resolution: |
Won't Fix
|
| Priority: |
Minor
|
| Assignee: |
Unassigned
|
| Reporter: |
Mark A Kruger
|
| Votes: |
0
|
| Watchers: |
1
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
CentOS, Apache 2.02, CF 7.01, Oracle 10g
|
|
|
File: edit.cfc in /Farcry_core/packages/Farcry/category.cfc
Line: on or about 225
Description:
Query of a query errors out with an data type error. QofaQ can't handle the CLOB data type from Oracle.
Fix:
Add a try catch around the distinct Q of a Q error. Ignore the error. This works for most cases, but it does mean duplicates are possible. This q of a q looked like a work around for duplicates to begin with.
NOTE: I did a search for this error and did not find it in the track - but I could swear I reported earlier.
|
|
Description
|
File: edit.cfc in /Farcry_core/packages/Farcry/category.cfc
Line: on or about 225
Description:
Query of a query errors out with an data type error. QofaQ can't handle the CLOB data type from Oracle.
Fix:
Add a try catch around the distinct Q of a Q error. Ignore the error. This works for most cases, but it does mean duplicates are possible. This q of a q looked like a work around for duplicates to begin with.
NOTE: I did a search for this error and did not find it in the track - but I could swear I reported earlier. |
Show » |
|
Oracle "CLOB" type errors out on Q of a Q