record set question

Results 1 to 2 of 2

Thread: record set question

  1. #1
    Newt Guest

    Default record set question

    When I get column data from a record set, it seems to store the numbers as a string even though they are defined in the database as numerics. What do I need to do with the rsRecordSet("column") to get them to be numbers that I can add, subtract, and the like?<BR><BR>Newton

  2. #2
    K Fowler Guest

    Default RE: record set question

    Goto You can find a VbScript Reference as well as a JScript Reference to provide additional help.<BR><BR>For a brief description, you can simply cast the rs values to whatever type you desire.<BR><BR>If you are looking for an Integer:<BR>MyVar = CInt(rsRecordSet("column"))<BR><BR>If you are looking for a Long:<BR>MyVar = CLng(rsRecordSet("column"))<BR><BR>If you are looking for a Double:<BR>MyVar = CDbl(rsRecordSet("column"))<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