i am doing a online shopping cart.

I have 2 tables here.
In table tblOrders, i change the datatype of the columns( SubTotal,TaxTotal and GrandTotal) and also in OrderItems table(cost) to money.
Then I received this error:



Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'SubTotal'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'TaxTotal'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'GrandTotal'. Use the CONVERT function to run this query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'SubTotal'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'TaxTotal'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'GrandTotal'. Use the CONVERT function to run this query.


my question here:
how to convert the varchar to money by using query language?

This is not a technical forum- this is a feeback forum. You need to ask this question in a technical forum. I would move it for you, however you don't mention what database technology your using.



Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Practically all of the posts in this forum are technical.

If this forum is actually supposed to be feedback (whatever that is), then why not let it be technical? It seems that's what most people want.

hi Hal Levy could you explain some, what is your meant by technical forum,feed back forum????
and you will move ngang'message to a technical forum



Ahmed Ali
Software Developer

Guys,

I would request "alyeng2000" and "cs001" to please put an end to discussing on "Hal Levy's" post and try helping "ngang" solving his problem.

Thanks for your understanding.


-Vijay G

How?

Please go into a bit more detail (e.g. post the relevant code if you are executing some query) on what you are doing that gives you this error.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

I hope this helps
CAST and CONVERT
Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality.

Syntax
Using CAST:

CAST ( expression AS data_type )

Using CONVERT:

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

Arguments
expression

Is any valid Microsoft® SQL Server™ expression. For more information, see Expressions.

data_type

Is the target system-supplied data type, including bigint and sql_variant. User-defined data types cannot be used. For more information about available data types, see Data Types.

length

Is an optional parameter of nchar, nvarchar, char, varchar, binary, or varbinary data types.

style

Is the style of date format used to convert datetime or smalldatetime data to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data types), or the string format when converting float, real, money, or smallmoney data to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data types).

SQL Server supports the date format in Arabic style, using Kuwaiti algorithm.

In the table, the two columns on the left represent the style values for datetime or smalldatetime conversion to character data. Add 100 to a style value to get a four-place year that includes the century (yyyy).

SELECT CONVERT(VARCHAR, CAST(123456.12 AS MONEY), 1)