Read Through the Parent Recordset Object

  • Article

Note

Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.

 

This code segment steps through the parent objRS_Parent Recordset object until an end of file occurs. For each parent recordset (directory for this example), the code segment outputs the values of the child recordsets (file names, sizes, and writes for this example).

The following pseudo-code divides the segment into sub-segments and shows the structure of the complete segment. The individual topic for each sub-segment describes the details of the code for that sub-segment.

intRS_Parent_Count = 0
Do While Not objRS_Parent.EOF
    intRS_Parent_Count = intRS_Parent_Count + 1
    strRecord = Left(CStr(intRS_Parent_Count) & ".      ", 4)
 
    ' Extract and Output Values for Non-Chaptered Columns
    ' Create a Child Recordset Object for Chaptered Columns
    ' Read through the Child Recordset Object, Extracting and Outputting Values for Chaptered Columns
    ' Close the Child Recordset Object
 
    objRS_Parent.MoveNext
Loop

The output when running the script with cscript.exe is similar to the following.

1.    c:\inetpub\iissamples\default
1.1.      learn.asp  4859  9/17/98 1:48:10 AM
1.2.      exair.asp  4641  6/16/98 6:22:58 AM
2.    c:\inetpub\iissamples\sdk\asp\applications
2.1.      session_vbscript.asp  1553  5/30/98 2:52:24 AM
2.2.      session_jscript.asp  1568  5/30/98 2:52:24 AM
2.3.      application_vbscript.asp  2011  5/30/98 2:52:24 AM
2.4.      application_jscript.asp  2017  5/30/98 2:52:24 AM
...

Extract and Output Values for Non-Chaptered Columns

Create a Child Recordset Object for Chaptered Columns

Read through the Child Recordset Object, Extracting and Outputting Values for Chaptered Columns

Close the Child Recordset Object