MX7 can't execute MAX()

[rayspeed]

I just upgraded the ColdFusion server with ColdFusion MX7. After the upgrade,
some of my existing working application have generated errors and stop working
after the upgrade. After days of diagnostic, I have figure out where the
problem is and narrowed down the root cause of it.

With the <CFQUERY> tag, the SQL statement of SELECT max(column) FROM table
stops working when there is more than 100 records in that table, but it works
perfectly fine with SQLPlus. The root cause of the issue is that MAX()
function will not be working throught ColdFusion if data type of the column is
NUMBER(). The only way to get away with the problem is either change the
source code with the application to use SELECT column FROM table ORDER BY
column DESC, or change the data type to VARCHAR2() instead of NUMBER().

I don't think that this is supposed to be the only solution and would like to
know other ways to fix this problem.

System: Windows Server 2003 Web Edition.
Database: Oracle 8.1.7

Thanks to everyone for any hints!

[Dan Bracuk]

I'm guessing driver problem. I've read other posts about Oracle stuff starting to crash after an upgrade and it always seems to be a driver problem.

I don't know the details.

[rayspeed]

I have actually tried to change to driver in C:\windows\system32 that was used by the ODBC connection. But the problem still persists.