Temporarily setting maximum pooled statements to 0 (on the datasource definition) may help too - try this out as well.
> > [Macromedia][SQLServer JDBC Driver]Unsupported data conversion. > > > > am really lost as all i seem to have added is the new column??? > > Probably your database has compiled and cached the execution plan and > the columns in the cached execution plan do not match the columns in the > tables anymore. To 'uncache' the execution plan just change something in > the query so the string with the SQL is different, i.e. add a space. > -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

