WDS Query System.Author problem

I'm using XP and WDS 3.01

When I query for System.Author it gets an error when writing the value.

Error: Type mismatch

I can get all other types (System.Title, System.Subject) and so on

Simple OLEDB + VBScript Example:

"SELECT Top 10 System.ItemName, System.Title, System.Author FROM SystemIndex"

document.write rs("System.ItemName")

document.write rs("System.Title")

document.write rs("System.Author")

Everytime it encounters System.Author there's an error.

I'm catching nulls and empty values.

Tried cStr(rs("System.Author") with no luck.

Also tried VB.Net and it returns System.String[] as the value.

Any suggestions

Hi Jeff,

Like I said, I'm catching the nulls. So that's fine.

I did a little more research,

System.Author and System.Keywords used to be (type="VT_LPWSTR") a string, and I would just output the data.

Now they are (type="VT_LPWSTR | VT_VECTOR") which is array of strings.

If I output varType(rs("System.Author") I get "8200", Array String

If I output rs("System.Author").type I get "12", adVariant

So it seems I have to loop through an array or collection.

The problem is that what ever I throw at it gives me an error and I've been looking for some type of sample with no luck.

It makes sense that MS would change these to arrays. Especially Keywords because they are typically multi-value fields and seems more efficient.

I would appreciate some sample code for vb to get the values.

-Thanks

My thoughts exactly, I tried treating it as a basic array of strings.

arrAuthors() = rs("System.Author")
msgbox arrAuthors(0)

--Error Type Mismatch line 1

arrAuthors = Array(rs("System.Author"))
msgbox arrAuthors(0)

If isArray(rs("System.Author")) then
arrAuthors = Array(rs("System.Author"))
msgbox arrAuthors(0)
End If

--Error Type Mismatch line 2

I tried all sorts of array functions. Something tells me that the recordset is thowing out some type of Object.

Just have to find a way of converting it into a basic array, then loop through.

I would love to see a confirmed snippet of code to get a value from these types of fields.

I'll keep trying!

-Thanks

I think I found something. I'm not positive if this article is connected in some way.

Is this possible Could someone please confirm if this article is connected to the problem I'm having

http://support.microsoft.com/kb/237536

From the link above: