|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
1.
category.cfc (32 kb)
|
|
Environment:
|
Shared host, *nix, Oracle 8i
|
|
|
Essentially, when trying to view, for example, news from a specific category, the SQL query would fail for Oracle because there is no LIMIT statement in oracle. Instead, ROWNUM has to be used. I have attached a fixed category.cfc file that seems to solve the problem for me.
In /core/packages/types/category.cfc around line 200 in function getDataQuery, I changed things to have a separate case for an oracle database using existing variables sqlMaxRows (changed from and sqlMaxRowsPre) and bSqlMax (which now takes values 0,1,2).
|
|
Description
|
Essentially, when trying to view, for example, news from a specific category, the SQL query would fail for Oracle because there is no LIMIT statement in oracle. Instead, ROWNUM has to be used. I have attached a fixed category.cfc file that seems to solve the problem for me.
In /core/packages/types/category.cfc around line 200 in function getDataQuery, I changed things to have a separate case for an oracle database using existing variables sqlMaxRows (changed from and sqlMaxRowsPre) and bSqlMax (which now takes values 0,1,2). |
Show » |
|
Bug
Resolved
Minor
Bad Oracle SQL Query for showing only specific categories in a rule