[RESOLVED] Querying Private Message XML Files
When you download your Private Messages in XMl format you get a file that looks like this
Code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- VBForums; http://www.vbforums.com -->
<!-- Private Message Dump For User MartinLiss; 01-29-2007 03:50 PM -->
<privatemessages>
<folder name="Sent Items">
<privatemessage>
<datestamp>2006-01-17 14:29</datestamp>
<title>The title</title>
<fromuser>MartinLiss</fromuser>
<touser>JohnQ</touser>
<message><![CDATA[yada yada.]]></message>
</privatemessage>
<privatemessage>
<datestamp>2006-01-18 13:35</datestamp>
<title>Hello There</title>
<fromuser>MartinLiss</fromuser>
<touser>Brad Jones</touser>
<message><![CDATA[blah blah]></message>
</privatemessage>
</folder>
</privatemessages>
Why is it that I can do the following to extrtact the PMs sent to me
Set oxmlNodeList = XMLdoc.documentElement.selectNodes("//privatemessage[touser='MartinLiss']/touser")
but I can't do this to get PMs after a certain date with code like this?
Set oxmlNodeList = XMLdoc.documentElement.selectNodes("//privatemessage[datestamp>'2007-01-01']/datestamp")
Re: Querying Private Message XML Files
I believe MSXML doesn't support XSLT 2.0 and thus can't compare dates.
This post might assist.
Re: [RESOLVED] Querying Private Message XML Files
