Subject:Newbie struggling with simple query Author:froz frozdick Date:01 Jun 2007 08:10 AM Originally Posted: 01 Jun 2007 08:09 AM
I've trimmed the files right back to simplify my problem and attached. In the data.xml doc there is potentially a number of elements tagged as <IP> per site. the vbs file also attached needs to query for an IP and have the value of the prefix tag returned. This all works fine where there is just one <IP> element but where I have a number of them, my query only seems to check the first one. I've obviously missed something blatantly obvious here.
Subject:Newbie struggling with simple query Author:froz frozdick Date:05 Jun 2007 04:54 AM Originally Posted: 05 Jun 2007 04:49 AM
>MSXML requires the two
>elements operands to be the
>same type, changing the
>expression as follow generates
>the expected result
>strQuery = "/sites/site[
>ip/text() = " & strIP
>Hope this helps
>Stylus Studio Team
You sir are a legend. Thank you very much.
Can anyone point me at a good reference site for this topic or a decent book please? It seems all I'm missing here now is the equivalent of instr. I'm sure I've read somewhere that I can use beginswith to achieve this but I've not been able to find any example. Essentially all I want to do is locate the element that contains the value of strIP at position 1.