thanks Ade, explains a problem I've had for a while :-) Jenny
-----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 08 January 2006 18:31 To: CF-Talk Subject: RE: Database schema caching Oh and I should have said, you'll likely be getting this because you have SELECT *, if you have the column names the SQL will be different and will force a new recompile. Ade -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: 08 January 2006 18:22 To: CF-Talk Subject: Database schema caching I just had this weird problem again today that I get every so often. I modify my SQL database, add some new tables or columns to an existing table, but CF cannot find them. I have to restart CF before it can see the changes I have made. Sometimes even restarting CF doesn't fix it. The queries themselves are not being cached, as they pickup new data added to existing tables. This is not specific to my dev server either, I have experienced this on multiple servers. Very weird. Anyone ever found the cause for this? Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228777 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
