|
lol
"When the only tool you have is a hammer, a sore thumb you will have."
|
|
|
|
|
Why LOL?
And why is my message gone!?
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
does anyone know how to tell the parser to ignore special characters in element attributes?
say i have an element:
<br />
<setting name="CommandLine" value="notepad.exe "C:\Documents and Settings\moralja\My Documents\text\text.txt""></setting><br />
this will not parse correctly because of the quote marks inside the value attribute.
just encoding the quotes with " works, but i am going to have possibly thousands of entries, i would rather have some way, like the CDATA thing, to tell the parser to ignore the data altogether
any ideas?
-John
|
|
|
|
|
John Morales wrote:
just encoding the quotes with " works, but i am going to have possibly thousands of entries, i would rather have some way, like the CDATA thing, to tell the parser to ignore the data altogether
I may be wrong but the answer is no. If you think about it having quotes like that in the attribute value breaks the whole parsing of the element.
I would recommend you move that attribute to an element e.g.:
<setting name="CommandLine">notepad.exe "C:\Documents and Settings\moralja\My Documents\text\text.txt"</setting>
It actually makes more sense that way too.
And if you think that will be a pain with thousands of entries, you could always write a simple XSL file which does it for you in a couple of minutes 
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
Simon Walton wrote:
"You come across a lot of people who call themselves realists, when they are actually pessimists attempting to look intelligent."
|
|
|
|
|
Hello;
I have trouble with XML. I have XML document like following;
root
A id="97033536"
B id="09417"
C id="09418"
D
E M18 /E
/D
/C
/B
B id="09417"
C id="09419"
D
E M18 /E
/D
/C
/B
/A
/root
I want to get data in 2 rows like;
97033536 09417 09418 M18
97033536 09417 09419 M18
How can i get this result in Visual Basic with DOM?
Thanks...
Ahmet Orkun GEDiK
|
|
|
|
|
One way is to create an XSL and then transform the XML. This can be done by creating two DOM Documents. Load the XML in one and the XSL in one. call TranformNode for the XML by passing the XSL. The XSL could look something like:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes">
<xsl:template match="/">
<xsl:apply-templates select="/A">
<xsl:template match="A">
<xsl:for-each select="B">
<xsl:value-of select="/A/@id">
<xsl:text>
<xsl:value-of select="/A/@id">
<xsl:apply-templates select="C">
<xsl:template match="C">
<xsl:text>
<xsl:value-of select="@id">
<xsl:apply-templates select="D">
<xsl:template match="D">
<xsl:text>
<xsl:value-of select="E">
I like this approoach because if you wish to chnage the format of your data later on all you have to do is change the XSL and your code remains the same.
|
|
|
|
|
Hello;
I have trouble with XML. I have XML document like following;
<root>
<c id="09418">
<d>
<e>M18
<c id="09419">
<d>
<e>M18
I want to get data in 2 rows like;
97033536 09417 09418 M18
97033536 09417 09419 M18
How can i get this result in Visual Basic with DOM?
Thanks...
Ahmet Orkun GEDiK
|
|
|
|
|
Hey Guys,
I am using ASP to load some data from a xml file via xsl. Now i need to sort this data, i know i could use the xsl:sort element but i need a dynamic one, which the user can change. So the user will have the possibilty to sort the data in different ways. I already tried to pass a param to xsl and put it to <xsl:sort> but it didnt worked.
Isnt it possible to pass a sort statement in selectnodes ?
Is there any such function ?
Any suggestions ??
thanks
Sonu
da sonu 
|
|
|
|
|
If you are using DOM then try the following. Based on the user's selections create an XSL with the appropriate sort and then apply it to your XML using the DOMDoc object.
|
|
|
|
|
I am using DOM, but i am not very familiar with that. Do you have any example code which might help me ?
da sonu
|
|
|
|
|
Hi,
try to put this code:
<xsl:sort order="ascending" data-type="text" select="//records/*[name() = $OrderField]"/>
Where the parameter $OrderField contains the name of the field to order.
Pau
|
|
|
|
|
hola,
i have this xml recordset which looks like this
<DataSet>
<User>
<ID>JoeG</ID>
<FNAME>Joli</FNAME>
<LNAME>Gantz</LNAME>
<SSN>400-00-0000<SSN
</User>
<User>
<ID>Joe4</ID>
<FNAME>Joseph</FNAME>
<LNAME>Gour</LNAME>
<SSN>500-00-0000<SSN
</User>
<User>
<ID>Joe4</ID>
<FNAME>Joseph</FNAME>
<LNAME>Gour</LNAME>
<SSN>500-00-0000<SSN
</User>
</DataSet>
Basically I am trying to find a way to transform this xml into something that will have two or however many users in a page element so the output would be something like this.
<DataSet>
<page>
<User>
<ID>JoeG</ID>
<FNAME>Joli</FNAME>
<LNAME>Gantz</LNAME>
<SSN>400-00-0000<SSN
</User>
<User>
<ID>Joe4</ID>
<FNAME>Joseph</FNAME>
<LNAME>Gour</LNAME>
<SSN>500-00-0000<SSN
</User>
</page>
<page>
<User>
<ID>Joe4</ID>
<FNAME>Joseph</FNAME>
<LNAME>Gour</LNAME>
<SSN>500-00-0000<SSN
</User>
<User>
<ID>Joe90</ID>
<FNAME>Joseph90</FNAME>
<LNAME>Ninety</LNAME>
<SSN>500-00-0000<SSN
</User>
<page>
</DataSet>
any one have any ideas as to how i can achieve this? I can get a page attribute around every user, but i would like to be able to put it around every X number of users, if anyone has any ideas i would really appreciate the help. sorry for the length of this post.
thanks
|
|
|
|
|
I just pasted in a snippet from a similar problem solution. The requirement here was to sort items before gouping them between DIV tags. It may shed some light on the grouping you need.
XML:
<?xml version="1.0"?>
<list>
<item at="d">d</item>
<item at="e">e</item>
<item at="i">i</item>
<item at="k">k</item>
<item at="l">l</item>
<item at="a">a</item>
<item at="b">b</item>
<item at="c">c</item>
<item at="j">j</item>
<item at="f">f</item>
<item at="g">g</item>
<item at="h">h</item>
<item at="a">a</item>
<item at="b">b</item>
<item at="c">c</item>
<item at="f">f</item>
</list>
XSL:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>
<xsl:param name="group">5</xsl:param> <!-- grouping size-->
<xsl:variable name="items" select="count(//item)"/> <!-- total number of items-->
<xsl:template match="list">
<HTML>
<BODY>
<xsl:apply-templates select="item">
<xsl:sort select="@at" order="ascending"/>
</xsl:apply-templates>
</BODY>
</HTML>
</xsl:template>
<xsl:template match="item">
<xsl:choose>
<xsl:when test="position() mod $group =1">
<!-- Begin new group with gn = group # -->
<xsl:variable name="gn" select="concat('g', (position() + 4) div 5)"/>
<!-- DIV id="g#" -->
<xsl:text disable-output-escaping="yes"><DIV id="</xsl:text>
<xsl:value-of select="$gn"/><xsl:text disable-output-escaping="yes">"></xsl:text>
<p><xsl:value-of select="position()"/>
<xsl:apply-templates/></p>
</xsl:when>
<xsl:when test="position() mod $group =0">
<!-- End group -->
<p><xsl:value-of select="position()"/>
<xsl:apply-templates/></p>
<!-- /DIV -->
<xsl:text disable-output-escaping="yes"></DIV></xsl:text><hr />
</xsl:when>
<xsl:when test="not(position() mod $group =0) and position() = $items">
<!-- last item in sorted list-->
<p><xsl:value-of select="position()"/>
<xsl:apply-templates/></p>
<!-- /DIV -->
<xsl:text disable-output-escaping="yes"></DIV></xsl:text>
</xsl:when>
<xsl:otherwise>
<p><xsl:value-of select="position()"/>
<xsl:apply-templates/></p>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
</xsl:stylesheet>
HTH,
Zdenek
"I would have written a shorter letter, but I didn’t have the time." [Blaise Pascal]
|
|
|
|
|
Hi all,
Trying to select some nodes (in script code),
i tried running this objNode.selectNodes("//NodeType[contains(@SomeAttribute,'SomeText')]")
when the browser (i.e. 6) runs the script, I get
msxml3.dll: Unknown method.
//NodeType[-->contains('@SomeAttribute'<--,'Test')]
Any ideas? According to the references, the contains function is implemented by MsXML3, is it not valid in this context???
|
|
|
|
|
I believe it is the context you have shown. Yes contains is valid in MSXML3.
If you insist in finding evil in me you will find it, whether it is there or not.
|
|
|
|
|
Hi guys, not well versed in XML here..
*** Update -- After reading a document on well formed XML, I realized that ampersands in XML attributes need to appear as & or the numeric code. Please Ignore this post. Thanks! ****
When I try to load the following XML string into a XmlDocument object (or IE for that matter)
<text>
<text3 pageUrl="cgi-bin/ubb/forumdisplay.cgi?action=topics&forum=General+NSX+Discussion&number=1&DaysPrune=1" />
</text>
I get the following error: [From IE]
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
A semi colon character was expected. Error processing resource 'file:///C:/VSProjects/WinForumProjects/WinForumInstallDirectory/ServerContentTest.xml'. Line 2, Position 65
The error occures right after the '&forum=' part of the attribute.
It would seem to be trying to parse the attribute as HTML or something. How can I get the object to ignore the actual values of the attribute?
Thanks
Jeff
|
|
|
|
|
Can you modify your post and turn off the html. Can not see the XML.
If you insist in finding evil in me you will find it, whether it is there or not.
|
|
|
|
|
You have a single & character in your xml. Character & cannot be used in text as it is used in markup (the same applies to < character).
Replace each occurence of a single character '&' by a sequence of 5 chars &_a_m_p_;. I can't write them here together for the browser would render them to a single &. Just get rid of '_' from the presented sequence.
HTH,
Zdenek
"It's never too late to have a happy childhood." [Tom Robbins]
|
|
|
|
|
Hi all,
I just need some help with an XPath query. I have a document like
<my_items>
<item name="number 1">
...
</item>
<item name="number 2">
...
</item>
<!-- note the mis-spelling below -->
<item naem="number 3">
...
</item>
</my_items>
and I would like to get (from a pointer to my_items) all elements with a "name" attribute where the attribute is not empty. That would be item 1 and 2 above.
I've tried with a query like
_bstr_t bstrQuery = "item[(string-length(@name) > 0)]";
- but it doesn't work.
Got any hints ? I really need a useful resource for practical knowledge about XPath. All I've got is Essential XML Quick Reference by Aaron Skonnard and Martin Gudgin. It's definately good - but despite its humble size rather heavy  I suppose a reference is supposed to be that though.
Well, thanks in advance for any help or pointers.
/Jan
|
|
|
|
|
make sure your using something newer than msxml2, which does not support string-length.
some resources:
http://www.w3.org/TR/xpath
http://www.vbxml.com/xsl/XPathRef.asp
http://www.zvon.org:9001/saxon/cgi-bin/XLab/XML/extras.html?stylesheetFile=XSLT/xpath.xslt&lang=eng
|
|
|
|
|
Thanks for the links - actually useful
I solved the problem yesterday by using @name != "" - but thanks anyway.
/Jan
|
|
|
|
|
correct way is
item[not(@name)]
"When the only tool you have is a hammer, a sore thumb you will have."
|
|
|
|
|
Dear all,
I try to select node from a XML file:
but always failed: there are nodes in the file
but the select result are no.
What wrong with my code or the structure/name of my XML file?
my code:
--------------------------
MSXML::IXMLDOMDocumentPtr pDoc = NULL;
MSXML::IXMLDOMElementPtr root;
MSXML::IXMLDOMNodePtr userParent, userNode;
MSXML::IXMLDOMNodeListPtr userList;
root = pDoc->documentElement;
userParent=root->selectSingleNode(_bstr_t("Users"));
strServer="gmitc-data3";
strVolume="d:\Shared Volume";
temp=strServer+"\\"+strVolume;
userList=userParent->selectNodes(_bstr_t\
("User[@Class1Root='"+temp+"']"));
for( int k=0; k<userList->Getlength(); k++)
{
m_nCount++;
userNode=userList->Getitem(k);
strUser=(LPCTSTR)_bstr_t(userNode->attributes\
->getNamedItem(_bstr_t("Name"))->text);
m_Grid.SetRows(m_nCount+1);
m_Grid.SetTextArray(m_nCols*m_nCount+2,strUser);
}// end for(userList)
---------------------------
my xml file:
---------------------------
<?xml version="1.0"?>"
<DMadmin>
<Class1BkupServer>
<Server Name="gmitc-data3" Full="No">
<SharedVolume Vol="d:\Shared Volume" Full="No"/>
</Server>
</Class1BkupServer>
<Class2BkupServer>
<Server Name="gmitc-data3" Full="No">
<SharedVolume Vol="d:\Shared Volume" Full="No"/>
</Server>
</Class2BkupServer>
<Users>
<User Name="laura" Quota="Basic" Department="" Location="" Phone="" Email=""
Class1Root="gmitc-data3\d:\Shared Volume" Class1Folder="laura_Class1_Data"
Class2Root="gmitc-data3\d:\Shared Volume" Class2Folder="laura_Class2_Data"/>
<User Name="ren" Quota="Middle" Department="" Location="" Phone="" Email=""
Class1Root="gmitc-data3\d:\Shared Volume" Class1Folder="ren_Class1_Data"
Class2Root="gmitc-data3\d:\Shared Volume" Class2Folder="ren_Class2_Data"/>
</Users>
</DMadmin>
---------------------------------
|
|
|
|
|
"User[@Class1Root='"+temp+"']" appears wrong at first glance, since all User tags are contained within the Users tag. thus, that xpath should read "Users/User[@Class1Root='"+temp+"']"
Also, you may want to develop on your local drive, and not over a network share. This eleminates a source of errors in your code, which may also be the reason.
* Edit: looking at your code (imagine that  ), I see you retrieve the User tag at an earlier step, and then run the above xpath on that node. Perhaps ensure it works from a local file instead of a network share.
|
|
|
|
|
I got an idea from your opinion.
Thanks a lot.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
