Query Caching Issues?

[BunBo900]

I have a test(on the server) and a development(localhost) sites so is the oracle database schemas. Both Oracle database schemas reside on the same server. I have the same datasource name for both schemas in the CF Administrators (local and server). For some reason, it seems to me that the data being pulled only from the test environment database eventhough I run the code on the development(localhost). I cleared the cache on the CF administrator.

Any advise would be great. Thanks.

 

[FALCONSEYE]

so, your datasources (in cf admin) on test and localhost are pointing to the oracle schema in test.

http://www.fuzzysiberians.com

 

[BunBo900]

That is what I thought at first.

This is what I have.

CF Admin on test pointing to DBTest schema
CF Admin on development pointing to DBDevl schema

Thanks.

 

[FALCONSEYE]

why not update a field in one of your tables in dbTest schema, then run your query in dev (dbDev)? if you are seeing the update in dbDev, then there is something else going on. Do they refresh dbDev?

http://www.fuzzysiberians.com