Extract and Output Values for Non-Chaptered Columns

  • 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 sub-segment iterates through all the fields of the objRS_Parent Recordset object and concatenates the values of the columns in the parent recordset, excluding any chaptered columns.

For intI = 0 to objRS_Parent.Fields.Count - 1 
    If objRS_Parent(intI).Name <> "Chapter" Then 
        strRecord = strRecord & "  " & objRS_Parent(intI).Value
    End If
Next
 
WScript.Echo(strRecord);

For the query properties set in this example, the strRecord variable is, for example, the following.

1.    c:\inetpub\iissamples\default