Possible MX 7/MySQL bug

[cptrguru]

If this isn't a bug, then I'll be shocked. I'm pulling a simple database query
from a MySQL database, but the page is displaying incorrect values. At first,
I thought it was a cache issue, but I've pulled every no-cache trick I know and
still get the bad data displayed.



Here is a snippet of the data in the database (pay particular attention to the
RSTR column):
+------+------+------+
| plyr | team | rstr |
+------+------+------+
| 373 | 9 | 5 |
| 497 | 9 | 4 |
| 522 | 9 | 5 |
| 552 | 9 | 5 |
+------+------+------+

Here is the query:
<cfquery name="getData" datasource="ootp">
select *
from roster
</cfquery>
<cfdump var="#getData#">

And here is what is returned (notice the zeros in the RSTR column):
+------+------+------+
| plyr | team | rstr |
+------+------+------+
| 373 | 9 | 0 |
| 497 | 9 | 0 |
| 522 | 9 | 0 |
| 552 | 9 | 0 |
+------+------+------+

The kicker is, when I adjust the SQL to specifically call the records with
RSTR = 4, the correct rows are returned with the wrong data!!! This tells me
that MX 7 is gathering the data successfully, just not displaying it correctly.

The adjusted query:
<cfquery name="getData" datasource="ootp">
select *
from roster
where rstr = 4
</cfquery>
<cfdump var="#getData#">

And here is what is returned (notice the zeros are STILL in the RSTR column,
even though the where statement SPECIFICALLY calls for records where RSTR = 4):
+------+------+------+
| plyr | team | rstr |
+------+------+------+
| 497 | 9 | 0 |
+------+------+------+

Hopefully, I'm doing something TERRIBLY wrong, but this is REALLY basic stuff
here! I sincerely hope this is an issue that can be resolved quickly, because
if it isn't, this is going to be a really bad problem for sites that use data
to dynamically create their pages!


~Rob in LS
PS: I've posted all my settings below


System Info:
============
Windows MX, SP2
MySQL v4.1.10a
Java JRE 1.5.0_01

MX 7 Server Settings > Caching:
===============================
Maximum number of cached templates = 0
Trusted cache = unchecked
Save class files = unchecked
Cache web server paths = unchecked
Maximum number of cached queries = 0

Browsers Tested:
===============
FireFox v1.0
- Use up to: 0KB of disk space for the cache
Internet Exploder v6.0
- Check for newer versions of stored pages = Every visit to the page

Cache options used in webpage:
==============================
<meta http-equiv="expires" content="0">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="Pragma-directive" content="no-cache">
<meta http-equiv="cache-directive" content="no-cache">

[Damon Cooper]

Hi, are you using the built-in or downloaded MySQL driver? Also note that
CFMX7 has not been tested and is not supported on JDK 1.5 yet.

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

Damon