Using CONVERT function

Discussion in 'ASP General' started by Bill, Jul 1, 2003.

  1. Bill

    Bill Guest

    I'm getting the following error:

    [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit
    conversion from data type varchar to data type money, table
    'bill.dbo.cart', column 'price'. Use the CONVERT function to run this
    query.

    Does anyone understand this function and how to use it? I'm trying to
    pull a quantity value from one table, multiply it times a price to get
    a total cost, and then stick the product into the new cart table.
    However, it seems like the quantity, which was a varchar, but has
    since been converted to a numeric, is still being viewed as a varchar.
    Can someone help me on this?

    Thanks a million,

    Bill
    Bill, Jul 1, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Andreas Klemt
    Replies:
    1
    Views:
    388
    Karl Seguin
    Jul 23, 2003
  2. Jaap
    Replies:
    4
    Views:
    707
    John O'Conner
    Jul 10, 2006
  3. Klaus Neuner
    Replies:
    7
    Views:
    486
    Klaus Neuner
    Jul 26, 2004
  4. sck10
    Replies:
    4
    Views:
    15,999
    daniel
    Sep 3, 2006
  5. Replies:
    5
    Views:
    1,924
    Wesley Hall
    Nov 4, 2006
Loading...

Share This Page