Lol - boy that wasen't so bad Thanks isaac
gabe -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 05, 2005 3:17 PM To: CF-Talk Subject: Re: Altering db causes error with perpaired statements > This has long irk'd me without a simple solution. When altering the db > (add > column) all the queries with prepared statements (aka > cfqueryparam) that > touch that table will toss an error about data types not right. Hey Gabe... The simple solution (you'll love this) is to disable the statement pool on your datasource... This eliminates the issue completely and doesn't noticeably affect performance. CF Admin > Data Sources > [yourdsn] > Advanced Settings > Max Pooled Statements = 0 s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:211178 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
