Results 1 to 2 of 2

Thread: loop

  1. #1
    Join Date
    Dec 1969

    Default loop

    can anyone tell me how to do loop for <BR>arraystart(0)=(2000-22-12 00:00:00)<BR>arrayend(0)=(2000-22-12 00:59:59)<BR>arraystart(1))=(2000-22-12 01:00:00)<BR>arrayend(1)=(2000-22-12 01:59:59)<BR>until<BR>arraystart(23)=(2000-22-12 23:00:00)<BR>arrayend(23)=(2000-22-12 23:59:59)<BR><BR>coz i need to retrieve the data from a table between arraystart(i) and arrayend(i)<BR><BR>thank you

  2. #2
    peterjl@austec.net.au Guest

    Default RE: loop

    If you mean that you open a recordset an then store the result in the array, it looks like this:<BR><BR>&#060;%<BR>Dim ar, row, col, rs<BR><BR> ar = rs.GetRows<BR>for row=0 to UBound(ar,2)<BR>for col=0 to UBound(ar,1)<BR> rsoponse.write ar(col,row) & ", "<BR>next<BR>response.write "<BR>"<BR>next<BR><BR>%&#062;<BR><BR>This will loop through the array displaying the values, comma delimited, each row on anew line.<BR><BR>Note: I have done this quickly of the top of my head, so I am not sure if I got the dimensions the right way

Posting Permissions

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