GetRows This is learned in the process of doing projects and sharing. Everyone may often encounter this situation: SQL = "Select * from table" SET RS = conn.execute (SQL) After the two sentences are executed, if you use the response.write rs.recordcount, you will get results - 1 But this time, the record set RS is actually recorded. In order to get the correct number of records, we use getRows.
SQL = "Select * from table" set = conn.execute (sql) arra = rGETROWS 'Turning a record set in a 2D array to Response.Write Ubound (Arra, 2) 1 will be recorded The total number of records, RESPONSE.WRITE Ubound (Arra, 1) 1 will get the total number of records
