Exhange WebDAV keys

[rabbit65]

I am trying to write an app that uses Exchange to store contact info but I need to relate the contact items to data which I store is a sql DB. I am using WebDAV to access a public contact store on an Exchange 2003 Server and I can't seem to find any docs that say what field would be best to use as a "permanent" key. I was thinking of using "permanenturl" until I read that the folder portion of the url can change if the item is moved.

Any ideas what would be a good key candidate?

I've tried ID and getetag but they do not return unique records when I submit queries.

Thanks in advance,
JB

 

[rabbit65]

Found my own answer as usual Seems that the where clause is case insensitive and the DAV:id field is a character representation of a binary value.

Here is the Microsoft KB rticle with an explnanation and a workaround.

http://support.microsoft.com/default.aspx?scid=/servicedesks/bin/kbsearch.asp?Article=320749