Data Conversion

Results 1 to 4 of 4

Thread: Data Conversion

  1. #1
    Sid Guest

    Default Data Conversion

    Hello,<BR><BR>I need help on converting a variable to a currency type, can you<BR>please tell how to achieve that or where I can find a source with different types of conversion functions.<BR><BR>Thanks,

  2. #2
    J Guest

    Default RE: Data Conversion

    try CCur(myValue)

  3. #3
    Sid Guest

    Default RE: Data Conversion

    Hello ccur(Price) does not work, here some more info on the problem. I&#039;m trying to give default values to non-mandatory<BR><BR><BR> if isnull(oPrice) then<BR> oPrice = "0"<BR> ccur(oPrice) <BR> end if<BR><BR>The error occurs in the following line:<BR><BR>Set objParam = objCommand.CreateParameter("@Price", adCurrency, adParamInput, ,oPrice)<BR><BR>Error Type:<BR>ADODB.Command (0x800A0D5D)<BR>Application uses a value of the wrong type for the current operation.<BR>/StockNet/UpdateData.asp, line 95<BR><BR>Please Help.<BR>

  4. #4
    J Guest

    Default RE: Data Conversion

    have you tried converting it to a double value: CDbl()?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts