RE: Database schema caching

2006-01-08 Thread Jennifer Gavin-Wear
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 h

RE: Database schema caching

2006-01-08 Thread Adrian Lynch
bject: 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

RE: Database schema caching

2006-01-08 Thread Adrian Lynch
I've seen it when query paraming before. I added a line break to my SQL and it fixed it. Although your problem sounds like it might be different. Ade -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 08 January 2006 18:22 To: CF-Talk Subject: Database schema cachin

Re: Database schema caching

2006-01-08 Thread Jochem van Dieten
Snake wrote: > > 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

Database schema caching

2006-01-08 Thread Snake
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 them