Mike Little wrote: > when i add the column, and run our products query we get the following > error... > > [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. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
