Results 1 to 7 of 7

Thread: Please Help

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2000
    Posts
    85

    Question

    I have a bunch of numbers that are being inserted into an html file and I want to calculate the total and place it in a cell at the bottom of the table. How would I do this in VBScript or JavaScript???
    Using VB6 Still Pluging away

  2. #2
    Frenzied Member Mark Sreeves's Avatar
    Join Date
    Nov 1999
    Location
    UK
    Posts
    1,845
    I have a bunch of numbers that are being inserted into an html file

    How?

    Please explain.
    Mark
    -------------------

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jun 2000
    Posts
    85
    The numbers come to the page from an Oracle view using SQL statements.
    Using VB6 Still Pluging away

  4. #4
    Frenzied Member Mark Sreeves's Avatar
    Join Date
    Nov 1999
    Location
    UK
    Posts
    1,845
    Are they numbers written directly to the page or are they in textboxes etc?
    Mark
    -------------------

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Jun 2000
    Posts
    85
    Directly to the page.
    Using VB6 Still Pluging away

  6. #6
    Hyperactive Member
    Join Date
    Mar 2000
    Posts
    292
    At the same time that the numbers are being written can't you keep a running total?
    "People who think they know everything are a great annoyance to those of us who do."

  7. #7
    Hyperactive Member
    Join Date
    Mar 2000
    Location
    Canada
    Posts
    264
    if you are using SQL, you can use the "sum" function in the SQL..

    something like:

    set rowcount 0 select sum(thenumbers) as theSum from table

    this will return you a field that will hold the sum of the numbers, so practically you can have 2 SQL's one to grab the numbers, and another for the summing, or you can combine them in one SQL that will return you both.
    In the beginning the universe was created. This has made a lot of people very angry and is generally regarded as a bad idea.

    - Douglas Adams
    The Hitchhiker's Guide to the Galaxy

Posting Permissions

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



Click Here to Expand Forum to Full Width