Connection between ColdFusion and MySQL

[besenok]

We are running ColdFusion MX on SunOS 5.8 with MySql located on the same server.

If we write any new information into the database, our ColdFusion application
is querying the database and is returning data that had just been replaced.
Upon restarting of ColdFusion this issue disappears. My assumption is that the
old data is being cached somewhere, but I don?t know where or how to trace its
occurrence.

Any suggestions would be greatly appreciated.

[swathi]

Hi,
Queries can be cached using cfquery tag and they can cached for certain
amount of time. Other then that there is no other way of caching in coldfusion
itslef. I do not totally understand your question though. If you update the
database table, if your application queries that table, you will get new data.
I am not sure why that will be a issue. Can you clarify your question.

Thanks,
Swathi.

[besenok]

Hi,

Thanks for replying. I was also mystified why the query was returning old data.
I mannually checked the database to see if the old data was still there, and
didn't find it, only the new data was present.
That is why I wanted to know where I could look in ColdFusion, or anywhere
else, where this data could be cached.

Thanks again.