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:
    369
    Karl Seguin
    Jul 23, 2003
  2. Jaap
    Replies:
    4
    Views:
    688
    John O'Conner
    Jul 10, 2006
  3. Klaus Neuner
    Replies:
    7
    Views:
    460
    Klaus Neuner
    Jul 26, 2004
  4. sck10
    Replies:
    4
    Views:
    15,976
    daniel
    Sep 3, 2006
  5. Replies:
    5
    Views:
    1,901
    Wesley Hall
    Nov 4, 2006
Loading...

Share This Page