Do you use "select *" in your queries? If you are, and you add another column, it's not unusual for CF not to pick up the change. It's an implicit caching that CF does.
On 11/4/05, Snake <[EMAIL PROTECTED]> wrote: > > 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:223267 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
