Here is how to fix your problem: 1. Login to your CF Admin 2. Go to the Data Source in question. 3. Change "Max Pooled Statements" to 0.
We had this exact same problem when adding or removing columns to a DB Table. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, March 25, 2005 3:16 PM To: CF-Talk Subject: RE: cfqueryparam caching data > I have a query that returns one row from the DB which uses > cfqueryparam. I'd heard about a problem with caching so after > a puzzling 30 seconds asking myself where my new column had > gone I thought I'd remove the cfqp which worked. Now when I > put it back in I still get the cached data. > > So the question is, how do I clear this cached data? I don't > want to restart anything but I don't mind running a SQL > statement. It's SQL Server 2K. So something like DBCC > FREEPROCCACHE but for statement. I'm not sure it's the CFQUERYPARAM which is causing the problem. Conceivably, you could have the same problem if you had a hardcoded value in your SQL, if your datasource is configured to generate prepared statements, and you might see the problem go away if you added a CFQUERYPARAM! If you add a column, and use "SELECT *", and the prepared statement is cached on the database server, your query often won't include the new column. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:200057 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
