Number Error

Results 1 to 2 of 2

Thread: Number Error

  1. #1
    Nathan Masek Guest

    Default Number Error

    I am getting an error that says the "Round" Function and the "FormatCurrency" Function cannot be used on my feild. They are numerical feilds and when I look at the raw data it says "0"<BR>I have tried putting the field into a variable and then using the functions on that but get the same error.<BR>Any ideas?<BR><BR>- Thanks<BR>- Nathan Masek

  2. #2
    Join Date
    Dec 1969

    Default RE: Number Error

    any field is an Object. you need to convert the value out.<BR><BR>in VBScript it *should* be passed by value so you can do this<BR><BR>intNum = rs("field")<BR>rounded = Round(intNum)<BR><BR>in JScript, do a parseInt() directly on the field. integers are passed by value by default (unlike strings)<BR><BR>j

Posting Permissions

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