Im stupid need help

Results 1 to 2 of 2

Thread: Im stupid need help

  1. #1
    dumb-ass Guest

    Default Im stupid need help

    Why will this not give me the answer of 3 if (rsSearch.Fields("FAQ_POPULARITY").Value) = 2 and<BR><BR>byOne = 1<BR><BR>(rsSearch.Fields("FAQ_POPULARITY").Value) +(byOne)

  2. #2
    Join Date
    Dec 1969

    Default Does it give you 21?

    If it gives you an answer of 21, then the problem is that the field FAQ_POPULARITY in the table is *not* a numeric field. It is probably (and likely incorrectly?) a text field of some kind.<BR><BR>I&#039;d recommend changing the field type. But you could fix the immediate problem via<BR><BR>CLng( rsSearch("FAQ_POPULARITY") )+ byOne<BR><BR>Just force the value from the DB to be a number.<BR><BR>Oh, and the reason: + *can* be interpreted by VBS to mean String Concatenation (same as & operator) when a string is on the left side of the + sign.<BR><BR>

Posting Permissions

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