Please help. I am a getting this error message: [Macromedia][SQLServer JDBC Driver][SQLServer]Disallowed implicit conversion from data type text to data type nvarchar, table 'WIW2U.dbo.db_Reso', column 'Category_Id'. Use the CONVERT function to run this query.
My column is of datatype nvarchar. using mssql 2000. Can someone tell me how I can use Convert while doing an insert statement. Please help with an example. Thanks, Ken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
