|
C# does not understand entities! Use escape sequences.
xn.SelectSingleNode("*[@text=\"Secretary\'s Office\"]");
|
|
|
|
|
Thanks, that did the trick. However you'd be up the creek if text contained both " and '
If the XML police saw the xml which contained ',",&,<,> wouldn't they give me a ticket?
|
|
|
|
|
Hello,
I need to create a XML to XML conversion with XSLT.
Could someone help me out with this?
My original XML is:
<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns = "http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode>
<siteMapNode
url = "~/Page01.aspx"
name = "Page01"
visible = "true" />
<siteMapNode
url = "~/Page02.aspx"
name = "Page02"
visible = "false" />
</siteMapNode>
</siteMap>
Would become:
<?xml version="1.0" encoding="UTF-8"?>
< urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
< url>
< loc>http://www.mydomain.com/Page01.aspx</loc>
< title>Page01</title>
</url>
</urlset>
So the following actions take place:
1. siteMap xmlns = "http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" becomes urlset xmlns="http://www.google.com/schemas/sitemap/0.84"
Node siteMap becomes node urlset.
2. The node "siteMapNode" becomes the node "url"
3. Only the nodes where attribute "visible" is "true" are copied to the new XML file.
4. Property visible is not copied to the new file.
5. Property "url" becomes node "loc" and "~" is replaced by "http://www.mydomain.com"
6. Property name becomes node title.
Well, I think I didn't forget anything.
Thank You Very Much
Miguel
|
|
|
|
|
I hope you got the idea but still what you are expecting from the people.. can you make it clear?
 Sathik
|
|
|
|
|
The easiest way to transform XML to another hierarchy is to use a combination of xsl:copy and xsl:copy-of.
|
|
|
|
|
Hi all
I am having a problem in my xslt and xml
this is my xml file:
<a1>
<property owner="Wallace Chan1" id="p002" type="condominium">
<owner>Some company1</owner>
<address>
<streetno>35</streetno>
<streetname>Kingsbridge Garden Circlen</streetname>
<city>Mississauga</city>
<zipcode>L5r3z5</zipcode>
<state>Ontario</state>
<country>Canada</country>
</address>
</property></a1>
and here is my xsl file:
<xsl:template match="/">
<html>
<head><title>CSCC09 assignment 1, phase 1</title></head>
<body> <h2>List of properties:</h2>
<xsl:for-each select="a1/property[@type='condominium']">
<xsl:apply-templates/>
</xsl:for-each>
</table>
<br/>
<h3>House</h3>
<table>
</body></html>
</xsl:template>
<xsl:template match="property">
<tr>
<xsl:apply-templates/>
</tr>
</xsl:template>
<xsl:template match="owner">
<td>
<xsl:value-of select="text()"/>
</td>
</xsl:template>
</xsl:template>
</xsl:stylesheet>
I want to display the owner infomation in a table for each property. This xsl is working well, however it is showing all the other infomation in address as well...
its showing up all the PCDATA in <address>, with all spaces removed, and then showing up all the owner infomation correctly in the table.
how can i removed all the unwanted PCDATA?
thx thx
|
|
|
|
|
<xsl:apply-templates/> needed to be written to filter out the unwanted data:
<xsl:template match="/">
<html>
<head>
<title>CSCC09 assignment 1, phase 1</title>
</head>
<body>
<h2>List of properties:</h2>
<table>
<xsl:apply-templates select="a1/property[@type='condominium']"/>
</table>
<br/>
<h3>House</h3>
</body>
</html>
</xsl:template>
<xsl:template match="property">
<tr>
<xsl:apply-templates select="owner"/>
</tr>
</xsl:template>
<xsl:template match="owner">
<td>
<xsl:value-of select="."/>
</td>
</xsl:template>
|
|
|
|
|
how can i enable debugging in web service?
my client cannot access the service if i create it in the wwwroot\folder\service... however it can access it wwwroot\service like this can i get a logical reason for this
bu
|
|
|
|
|
I have an XML server control places in an aspx-page. The document-source is ="inhoud.xml" and the transformSource="inhoud.xslt. When I run it, it returns "'xsl' is an undeclared namespace".
What am I missing here? What do I do wrong?
A xls-newbie...
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="xsltest.aspx.vb" Inherits="StyleSheetTest.xsltest"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>xsltest</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body>
<form id="Form1" method="post" runat="server">
<asp:Xml id="Xml1" runat="server" DocumentSource="inhoud.xml" TransformSource="inhoud.xslt"></asp:Xml>
</form>
</body>
</HTML>
content of inhoud.xlst:
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/website">
<xsl:apply-templates select="website">
<xsl:apply-templates select="pagina">
<p><xsl:value-of select="pid"/></p>
<p><xsl:value-of select="rangnr"/></p>
<p><xsl:value-of select="titel"/></p>
<p><xsl:value-of select="inhoud"/></p>
</xsl:apply-templates>
</xsl:apply-templates>
</xsl:template>
</xsl:stylesheet>
Content of inhoud.xml:
<?xml version="1.0" encoding="utf-8" ?>
<website>
<pagina>
<pid></pid>
<rangnr></rangnr>
<titel></titel>
<inhoud></inhoud>
</pagina>
</website>
|
|
|
|
|
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
led mike
|
|
|
|
|
Sometimes I am so blind.... thanks Mike
|
|
|
|
|
Hi,
I have some webservice running on windows 2003 machine over SSL (Does not require client certificate. SSL, just to encrypt the data).
I made a client in VB6 which uses Soap Toolkit 3 to access the webservice.
Everything works fine if I use the client on windows2003 or windows XP machine. Client can deal with the webserice using "https" URL.
But, when I tired running the client over win2000 machine, it gave me following error.
---
Connector:Unspecified HTTP error. HRESULT=0x800A1518 - Client:An unanticipated error occurred during the processing of this request. HRESULT=0x800A1518 - Client:Sending the Soap message failed or no recognizable response was received HRESULT=0x800A1518 - Client:Unspecified client error. HRESULT=0x800A1518
----
Then I changed the code so that it references the webserice with "http". It worked.
Then what I figured out is..
On win2000 machine when I wrote the url with "https" in browser, I got security warning "u r about to see secure item". This warning was not seen when I wrote the URL in win2003 and XP. So, I think the Soap Toolkit can not deal with that security warning?
Can anybody tell me how to solve this?
Any help will be appreciated.
- PPT
|
|
|
|
|
Looks like you have a space just after the "<" of the "employee_db" element. XML does not support spaces there.
|
|
|
|
|
i just checked the XML file and there is no problem with the spaces.the code in file is:
<?xml version="1.0" ?> <br />
<employee_db />
now can u tell me the problem with the code???
|
|
|
|
|
No, you haven't given me enough information to diagnose your problem. Also, your original question is missing?
Now, can you give me more information and more code?
|
|
|
|
|
Hi I am tring to read a xml in vs2005
I sent a post a few days ago and was hoping to revist the problem with the small pregress I have made.
here is the vb.net code:
Dim ds As New DataSet
ds.ReadXml(xmlout)
ds.WriteXml("C:\Query.xml")
here is the xml doc i am reading:
<?xml version="1.0" encoding="Windows-1252"?>
<InvQuery Language='05' CssStyle='' DecFormat='1' DateFormat='01' Role='01' Version='6.0.015'>
etc
my code keeps raising the following exception: "illegal characters in path"
I have noticed when I remove the attributes in the below line to just:
<InvQuery>
The code executes just as it should can anyone help with this problem pleeze =)
Cheers Dom
|
|
|
|
|
Just a guess, did you try changing the SingleQuote characters delimiting attribute values to DoubleQuote characters?
led mike
|
|
|
|
|
System.IO.StreamReader sr = new System.IO.StreamReader(@"C:\Query.xml");
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(sr);
ds.ReadXml(xtr);
ds.WriteXml("Querytest.xml");
I have done this with your XML and it works perfectly.
|
|
|
|
|
|
Hi all.
I exported an excel file with 29 coloums as a xml spreadsheet, this I want to import into my C# app.
basic structure that it I'm going to use is
<row>
<cell><Data ss:Type="Number">1</Data></cell>
<cell><Data ss:Type="String">SomeData</Data></cell>
<cell ss:Index="4"><Data ss:Type="String">MoreData</Data></cell>
</row>
No, column 3 was blank, so it gave me the Index of the next xml entry. Want I want to know is...
The attribute of the cell, is it just "Index" or is it "ss:Index" ????
Thanx in advance
-- modified at 5:47 Tuesday 3rd October, 2006
He who laughs last is a bit on the slow side
|
|
|
|
|
The "ss" of "ss:Index" is the namespace as defined in document element:
<br />
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"<br />
xmlns:o="urn:schemas-microsoft-com:office:office"<br />
xmlns:x="urn:schemas-microsoft-com:office:excel"<br />
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"<br />
xmlns:html="http://www.w3.org/TR/REC-html40"><br />
...<br />
</Workbook><br />
Also, "ss" is the default namespace of the XML document. You have to account for this namespace before you can access the "Index" attribute via a program, XPath or XSLT.
|
|
|
|
|
Thanks for the quick reply, looks like I need to first sharpen my xml knowledge (alot)
He who laughs last is a bit on the slow side
|
|
|
|
|
Hi all,
How can i set a path in the xml file and use it in the xsl style sheet?
example: the path could be "C:\image.jpg"
I want to be able to set the path in the xml file because this file gets created by our program and the user can change the path, that is why i dont want to do it as followed: <fo:external-graphic src="c:\image.jpg"/> this is a part from my xsl file but i cant use it like this any more...
thank you in advance... 
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
Kindly help me in my peoject
#sanroop#
|
|
|
|
|
To do what, exactly?
Steve S
Developer for hire
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
