I have an issue anytime I update my db structure. The queries im using with queryparams that reference the modified table toss data type mismatch errors. I assume this is because the prepared statement is no longer is in sync with the table.
I have only been able to correct by restarting cf or the db. I have tried refresh the cf odbc services to no avail. Anyone know a sql command to purge all prepared statements? Gabe Ps. Using ms sql 2000 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207430 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
