|
redbrad0
Advanced Member
USA
3725 Posts |
 Posted - 05 June 2001 : 08:48:25
|
I get this following error when trying to add data into my sql database...
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type varchar to data type money, table 'freeaspcodesql.dbo.ExhibitParts_Orders', column 'OR_Product_Total'. Use the CONVERT function to run this query.
Here is the sql string I am using...
INSERT INTO ExhibitParts_Orders (OR_Customer_ID, OR_Date_Ordered, OR_Product_Total, OR_Shipping_N_Handling_Total, OR_Taxes_Total, OR_Products_Ordered, OR_CCType, OR_CCNumber, OR_CCCardHolderName, OR_ExpirationMonth, OR_ExpirationYear, OR_ProductShipMethod) VALUES (1, '6/5/2001 7:50:52 AM', '0.01', '19.39', '0.00', '4-1-.01|', 'Master Card', 'hghgf', 'Brad Wickwire', '02', '2003', 'FedEx Saturday')
can anyone tell me what the CONVERT function for money is in SQL Server?
Brad |
|
Topic Locked
