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. Advertisements

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:
    572
    Karl Seguin
    Jul 23, 2003
  2. Jaap
    Replies:
    4
    Views:
    916
    John O'Conner
    Jul 10, 2006
  3. Klaus Neuner
    Replies:
    7
    Views:
    821
    Klaus Neuner
    Jul 26, 2004
  4. sck10
    Replies:
    4
    Views:
    16,418
    daniel
    Sep 3, 2006
  5. Replies:
    5
    Views:
    2,187
    Wesley Hall
    Nov 4, 2006
  6. Harlin Seritt
    Replies:
    29
    Views:
    1,523
    Paul Rubin
    Feb 24, 2007
  7. Samuel R. Neff
    Replies:
    0
    Views:
    1,281
    Samuel R. Neff
    Jan 2, 2008
  8. Replies:
    2
    Views:
    352
    John Bokma
    Aug 30, 2013
Loading...