Scott Raley wrote: > okay.. i need some ideas here... have an app that is using mySQL as the > backend..CF server running on a Solaris OS.... having some really weird > problems... I don't have hands on with this, must do everything remotely.. I'm > using mycfadmin and quickadmin to do some of the admin tasks... well data that I > delete appears to be coming back from time to time.. or was it really deleted? > .. not sure.. I can delete something in mycfadmin.. sometimes its gone if I > check quickadmin.. I can go to the front end and pull up the report and it > appears to be gone... 5 minutes later its in the report.. still doesn't show up > in quickadin but does appear in mycfadmin.. .. all my cache is clear.. I've > tried IE, Netscape and Mozilla .. all have the same results.. Found out that > if I select a link on the front end sometimes the query gives me different data > then what I selected.. because it appears that I have two data items pointing to > 1 unique id number... not sure how this could have happened.. but based on the > url parameters thats what it appears is happening....
When in doubt, start ruling out stuff by taking it out of the qequation. I'm sure MySQL has some command line editor like SQL+ or psql that can be used to connect directly to the database. Use that to run some queries to see what the data really looks like. Also, if you are using something with transactions, read up on them. It might be that you are in read commited mode without knowing it (don't know if MySQL even has that, but you get the point). Only after you have verified that the data is correct it is time to look at the next step. I believe that is query caching in MySQL itself (I believe it did that, could also be just execution plan caching). Only if there is nothing wrong there it is time to start looking at ColdFusion. Just my EUR 0.02 Jochem ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
