We've been using CFMX7 for a while now and all works fine. I've recently been asked to build a couple of new web servers and to use CFMX6 as they are for internal sites only. These sites are currently being served by the CFMX7 servers.
Very basically (as I don't really do the code side of things), we have a query that gathers data from several tables to build the query results.
These results are then queried in a CFLOOP for producing the page to output.
The problem is that in the query of queries we use a MIN() aggregate. In CFMX7 we get the correct results, but in CFMX6 what ever the value we get a float returned (something like 9.2576634E+18). We believe it to be because of the MIN() function but can't find any reference to say that this doesn't work or there are problems with this in CFMX6.
Any ideas??
Very basically (as I don't really do the code side of things), we have a query that gathers data from several tables to build the query results.
These results are then queried in a CFLOOP for producing the page to output.
The problem is that in the query of queries we use a MIN() aggregate. In CFMX7 we get the correct results, but in CFMX6 what ever the value we get a float returned (something like 9.2576634E+18). We believe it to be because of the MIN() function but can't find any reference to say that this doesn't work or there are problems with this in CFMX6.
Any ideas??
