Help with syntax "rst.fields(0).value"

[FancyPrairie]

I issue a LDAP query which returns a recordset containing 8 fields (i.e. sn, uid, telephoneNumber, roomNumber, employeeNumber, givenName, displayName, cn).


The type of the first field returned ("cn") is an "array of variant". The type of the 2nd field returned ("displayName") is a string. In Debug, it looks like this:

Name                    Value             Type
orst.fields(0).value    {...}             Array of Variant
    (0):                "MyName"          String
orst.fields(1).value    "MyDisplayName"   String

If I reference (in code) orst.fields(0).value, I receive an error. However, I don't get an error on orst.fields(1).value.

What is the syntax for referencing the value of the first field (whose type is an array of variant)?

I've tried orst.fields(0)(0).value and every combintation I can think of.

 

[FancyPrairie]

Nevermind...figured it out

 

[sarahtoms]

FancyPrairie,

What was your solution? I'm running into the same problem and could use some help.

Thanks!