what does the following piece of code do? its in asp?

Question

Set RS=Conn.Execute("sp_P_List_Employees '"&Session("UID")&"'")
if not RS.BOF or not RS.EOF then
ArrayEmployees=RS.GetRows()
end if
RS.Close

Set RS=Conn.Execute("sp_P_List_All_Appraisal_Type")
if not RS.BOF or not RS.EOF then
ArrayAllType=RS.GetRows()
end if
RS.Close

Answer 1

The first line is executing a stored procedure in SQL. This procedure is written for view an employee from a list of employees once the used ID is given as UID. (As I guess by name). Then, if the retrieved data set (or record set) is not empty, (means you are not in BOF (begin of file) or EOF (end of file), read a row of data and load it to the array “ArrayEmplyees”. Then it’ll close the record set object. This is what happening as far as I know. Hop this helps!