Russ, I get somewhat similar behavior depending on how I add the data in question. I access the database in two ways: through ColdFusion code and through TOAD (a SQL client on my desktop). If I go through TOAD and I issue a regular INSERT statement and ask it to execute, I will immediately see the new row when I query it in ColdFusion. However, if I put the INSERT statement in as one of many and run it as a script, I will NOT see the new row in ColdFusion. I always forget about this, then remember that I have to issue an explicit "commit" command to the client in order for the row to show up in ColdFusion.
Now, I hardly know what the commit command does. I admit to being a little database-stupid. But it seems clear that something of the nature of the database commands can be done in two different ways. In one way, it "commits", and in the other, is does not. So, if the developers in question are adding this data through tools outside of ColdFusion (like TOAD, for example), maybe this is the issue? HTH, Matthieu -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 11:02 AM To: CF-Talk Subject: FW: Strange DB behaviour This is a weird problem we have once in a blue moon, I keep forgetting to ask if anyone else has had it. Sometimes a developer adds a new table or a new field to an exisitng data, or even a new row of data. But ColdFusion thinks it doesn't exist. We get an error saying no such table or column, and the resultset will not include the new row. And no the queries are not being cached (as least not in the code). I had experienced this on many different servers in different locations, and it appears to be random. I have had to reboot the server in most cases to get rid of the problem. -- Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
