Array Woes

Results 1 to 3 of 3

Thread: Array Woes

  1. #1
    Speezer Guest

    Default Array Woes

    I am new to using arrays and I am having trouble finding a good article that explains how you display the output once you have placed the recordset into the array. Below is my SQL statement, and then the code to put it into an array. What I want to do now is display the list of each LSRStatus(the field I&#039;m pulling in my SQL statement) along with the count of each next to it like this:<BR>Confirmed 20<BR>BCIN 15<BR>PCIN 46<BR>etc.<BR>SQL = "SELECT LSRStatus, DatePart(dw,LSRStart), Count(*) AS Cnt " _<BR> & "FROM LSR2DEV " _<BR> & "WHERE LSRStart BETWEEN &#039;"& firstDayOfWeek &"&#039; AND &#039;"& lastDayOfWeek &"&#039;" _<BR> & " GROUP BY LSRStatus, DatePart(dw,LSRStart)" _<BR> & " ORDER BY LSRStatus, DatePart(dw,LSRStart)"<BR>set RSTotal = Conn.Execute(SQL)<BR>StatusArray = RSTotal.GetRows

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Array Woes

    See if this helps<BR><BR>

  3. #3
    Speezer Guest

    Default Excellent. Thanks. <eop>


Posting Permissions

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