WebDAV search to get last name

[csteinhilber]

I'm using classic ASP to create a WebDAV search of all appointments in a given (public) calendar. And I'm able to retrieve the creator of the given appointment ("urn:schemas:httpmail:fromname"), as well as their email address ("urn:schemas:httpmail:fromemail").

    strDAVsql = "<d:sql> SELECT ""DAV:href"", " & _
        " ""urn:schemas:calendar:dtstart"", " & _
	" ""urn:schemas:httpmail:fromname"", " & _
	" ""urn:schemas:httpmail:subject"", " & _
	" ""urn:schemas:calendar:location"", " & _
        " ""urn:schemas:calendar:dtend"", " &_   
        " ""urn:schemas:httpmail:fromemail"" " & _
        " FROM Scope('SHALLOW TRAVERSAL OF ""[URL unfurl="true"]http://domain.com/public/room1""[/URL] ')" & _
        "WHERE ""DAV:contentclass"" = 'urn:content-classes:appointment'" & _
        "AND ""urn:schemas:calendar:dtstart"" &lt;= " & _
        "CAST(""" & sAppntEnd & """ AS ""dateTime.tz"")" & _
        "AND ""urn:schemas:calendar:dtend"" &gt;= " & _
        "CAST(""" & sAppntStart & """ AS ""dateTime.tz"") ORDER BY ""urn:schemas:calendar:dtstart"""

It works quite nicely.

Except, I really kinda need the creator name split out to first name/last name.

I believe I'd need to use the urn:schemas:contact namespace to do this, but I've been unable to figure out exactly how.

Anybody have any ideas?

Thanks in advance!
-Carl