Problem with decimal column

Results 1 to 3 of 3

Thread: Problem with decimal column

  1. #1
    Molly Liu Guest

    Default Problem with decimal column

    Hi,<BR><BR>I got problem when try to read a decimal column from RecordSet: <BR><BR>Response object error &#039ASP 0101 : 80070057&#039 <BR>Unexpected error <BR>/wb_or1/login.asp, line 124 <BR>The function returned &#124. <BR><BR>The code on line 124 is:<BR><BR>Response.write MyRecordSet("balance")<BR><BR>The database is Informix.<BR><BR>It has no problem when column type is integer, but I can not use integer for balance.<BR><BR>Can anyone help on this? Thanks in advance.

  2. #2
    Amit Jain Guest

    Default RE: Problem with decimal column

    Have you tried response.write CStr (MyRecordSet("balance"))<BR><BR>Also, what is the line before line 124? ASP doesn&#039t always report the right line number :[

  3. #3
    Molly Liu Guest

    Default RE: Problem with decimal column

    I have tried that, then got the error below:<BR><BR>Microsoft VBScript runtime error &#039 800a0005&#039 <BR>Invalid procedure call or argument: &#039CStr&#039 <BR>/wb_or1/login.asp, line 124<BR><BR>There is someting interesting that the error only happens when the last digit of balance value is zero. For example, if the balance is 500.00 or 100.00, then it gives error, but it is no problem with 501.00, 437.00, so on and so forth.<BR><BR>It&#039s also fine if I change the balance from decimal to integer.

Posting Permissions

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