Results 1 to 10 of 10

Thread: Multiple Returns, but one Row.. how do I read them -> Resolved

Threaded View

  1. #1

    Thread Starter
    Frenzied Member RudyL's Avatar
    Join Date
    Mar 2001
    Location
    Chicago
    Posts
    1,519

    Resolved Multiple Returns, but one Row.. how do I read them -> Resolved

    I am using a single SQL to get several values: Count, Average, stdDev, Min, and MAX.

    I am using the command and reader style. Example:
    HTML Code:
    Command.Commandtext = SQLstring
    Reader = Command.ExecuteReader
    
    While Reader.Read = True
         debug.writeline(reader.getvalue(0))
    end while
    The problem is that I am only able to read the Count result.. How do I see them all?

    Rudy
    Last edited by RudyL; Dec 8th, 2004 at 10:20 PM.
    10 different ways to skin a cat and amazingly enough each and every one has the same result, the cat gets skinned! The same can be applied to code, so be nice and accept each others "preferences".

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