Why doesn't this work with XPath 1.0?

[MikeL]

I'm using .Net 2.0. I realize that this means XPath 1.0 (which is
ridiculous).

So here's a document that I have that's not on disk but held in a variable
(I queried an Exchange appointment calendar):

<?xml version="1.0"?>
<a:multistatus xmlns:b="urn:uuid:c2f41010-65b3-11d1-a29f-00aa00c14882/"
xmlns:d="urn:schemas:httpmail:" xmlns:f="urn:schemas:mailheader:"
xmlns:c="xml:" xmlns:e="urn:schemas:calendar:" xmlns:a="DAV:">
<a:prop>
<a:parentname>http://mail.somewhere.com/davrdir/john.doe/Calendar/</a:parentname>
<d:subject>busy</d:subject>
<e:dtstart b:dt="dateTime.tz">2006-12-08T13:00:00.000Z</e:dtstart>
<e:dtend b:dt="dateTime.tz">2006-12-08T15:00:00.000Z</e:dtend>
<e:created b:dt="dateTime.tz">2006-09-13T19:26:18.000Z</e:created>
<e:lastmodified b:dt="dateTime.tz">2006-09-13T19:26:19.000Z</e:lastmodified>
<e:alldayevent b:dt="boolean">0</e:alldayevent>
<e:busystatus>BUSY</e:busystatus>
<e:recurrenceid b:dt="dateTime.tz">2006-12-08T13:00:00.000Z</e:recurrenceid>
<f:message-id>&lt;21************************************@dpex ch.Alarmo.net&gt;</f:message-id>
</a:prop>
</a:multistatus>

This is actually an exerpt from an entire document, so there are several
<a:propnodes.

I need to know the number of <a:propelements where the <e:dtstart>
element's value is between a date range and e:busystatus="BUSY".

The XPath expression that I'm trying to use is:
//a:prop[e:dtstart >= "2006-12-08T00:00:00.000Z" and e:dtstart <=
"2006-12-08T23:59:59.000Z" and e:busystatus="BUSY"]

This works great using XPath 2.0 but not with XPath 1.0. I know this because
I'm using XMLSpy to test my expressions.

Why is this? How can I do what I need to in .Net 20.?

Thanks in advance,

Mike

[MikeL]

I failed to mention that I'm using the "Select" method of the
DocumentElement attribute of the XMLDocument object.

Thanks.

"MikeL" <mi******@optonline.netwrote in message
news:uS**************@TK2MSFTNGP04.phx.gbl...

I'm using .Net 2.0. I realize that this means XPath 1.0 (which is
ridiculous).

So here's a document that I have that's not on disk but held in a variable
(I queried an Exchange appointment calendar):

<?xml version="1.0"?>
<a:multistatus xmlns:b="urn:uuid:c2f41010-65b3-11d1-a29f-00aa00c14882/"
xmlns:d="urn:schemas:httpmail:" xmlns:f="urn:schemas:mailheader:"
xmlns:c="xml:" xmlns:e="urn:schemas:calendar:" xmlns:a="DAV:">
<a:prop>
<a:parentname>http://mail.somewhere.com/davrdir/john.doe/Calendar/</a:parentname>
<d:subject>busy</d:subject>
<e:dtstart b:dt="dateTime.tz">2006-12-08T13:00:00.000Z</e:dtstart>
<e:dtend b:dt="dateTime.tz">2006-12-08T15:00:00.000Z</e:dtend>
<e:created b:dt="dateTime.tz">2006-09-13T19:26:18.000Z</e:created>
<e:lastmodified
b:dt="dateTime.tz">2006-09-13T19:26:19.000Z</e:lastmodified>
<e:alldayevent b:dt="boolean">0</e:alldayevent>
<e:busystatus>BUSY</e:busystatus>
<e:recurrenceid
b:dt="dateTime.tz">2006-12-08T13:00:00.000Z</e:recurrenceid>
<f:message-id>&lt;21************************************@dpex ch.Alarmo.net&gt;</f:message-id>
</a:prop>
</a:multistatus>

This is actually an exerpt from an entire document, so there are several
<a:propnodes.

I need to know the number of <a:propelements where the <e:dtstart>
element's value is between a date range and e:busystatus="BUSY".

The XPath expression that I'm trying to use is:
//a:prop[e:dtstart >= "2006-12-08T00:00:00.000Z" and e:dtstart <=
"2006-12-08T23:59:59.000Z" and e:busystatus="BUSY"]

This works great using XPath 2.0 but not with XPath 1.0. I know this
because I'm using XMLSpy to test my expressions.

Why is this? How can I do what I need to in .Net 20.?

Thanks in advance,

Mike

[Martin Honnen]

MikeL wrote:

The XPath expression that I'm trying to use is:
//a:prop[e:dtstart >= "2006-12-08T00:00:00.000Z" and e:dtstart <=
"2006-12-08T23:59:59.000Z" and e:busystatus="BUSY"]

This works great using XPath 2.0 but not with XPath 1.0. I know this because
I'm using XMLSpy to test my expressions.

Why is this?

The reason is that the comparison operators <, >, <=, >= in XPath 1.0
operate only on XPath number values so they first convert the operands
to numbers and then compare them. And converting a string with e.g.
"2006-12-08T00:00:00.000Z" into a number does not give a number that can
be compared meaningfully as a date/time.

How can I do what I need to in .Net 20.?

With the format you have you might be able to use e.g.
//a:prop[translate(e:dtstart, '-T:Z', '') >=
translate('2006-12-08T00:00:00.000Z', '-T:Z', '') and
translate(e:dtstart, '-T:Z', '') <=
translate('2006-12-08T23:59:59.000Z', '-T:Z', '') and e:busystatus = "BUSY"]

That way the comparison happens on numbers like 20061208235959.000.

..NET 2.0 also has support for extension functions to do string
comparison. And EXSLT.NET might have more support for dealing with
date/time values.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[MikeL]

Thanks, Martin.

"Martin Honnen" <ma*******@yahoo.dewrote in message
news:OE**************@TK2MSFTNGP04.phx.gbl...

MikeL wrote:

>The XPath expression that I'm trying to use is:
//a:prop[e:dtstart >= "2006-12-08T00:00:00.000Z" and e:dtstart <=
"2006-12-08T23:59:59.000Z" and e:busystatus="BUSY"]

This works great using XPath 2.0 but not with XPath 1.0. I know this
because I'm using XMLSpy to test my expressions.

Why is this?

The reason is that the comparison operators <, >, <=, >= in XPath 1.0
operate only on XPath number values so they first convert the operands to
numbers and then compare them. And converting a string with e.g.
"2006-12-08T00:00:00.000Z" into a number does not give a number that can
be compared meaningfully as a date/time.

>How can I do what I need to in .Net 20.?

With the format you have you might be able to use e.g.
//a:prop[translate(e:dtstart, '-T:Z', '') >=
translate('2006-12-08T00:00:00.000Z', '-T:Z', '') and translate(e:dtstart,
'-T:Z', '') <= translate('2006-12-08T23:59:59.000Z', '-T:Z', '') and
e:busystatus = "BUSY"]

That way the comparison happens on numbers like 20061208235959.000.

.NET 2.0 also has support for extension functions to do string comparison.
And EXSLT.NET might have more support for dealing with date/time values.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/