When the database reads a lot of data.
Concatenate a string in the following format: STR = 1 ### 0 ### 1 ***** 2 ### 1 ### 1_1 ***** 3 ### 1 ### 1_2 ***** 4 ##2 ### 1_1_1 ***** 5 ### 2 ### 1_1_2 ***** 6 ### 4 ### 1_1_1_1 ***** 7 ## 6 ##1_1_1_1
Then, arrresult = Split (STR, "***") is used to divide STR into arrays, and then arrtmp = Split (arrresult (I) is used for each data entry in the arrresult array ),.
CodeAs follows:
Dim myarry ()
Arrresult = Split (STR ,"***")
For I = 0 to ubound (arrresult)
Arrtmp = Split (arrresult (I ),"###")
For J = 0 to ubound (arrtmp)
Redim myarry (ubound (arrresult), ubound (arrtmp ))
Myarry (I, j) = arrtmp (j)
Response. Write myarry (I, j) & "<br>"
Next
Next
When I try again
For k = 0 to ubound (myarry, 1)
Response. Write myarry (k, 1) & "<br>"
Next
When I want to display the video, how does the data in the array disappear?