XML / XSL

Re: Exception: "XsltContext is needed for this query because of an unknown function"

20-Oct-11 22:57

I would like to convert the text data to uppercase and I wrote the expression as below

"/RawData/page/text[upper-case(.)='ABC']"

its throwing an exception "XsltContext is needed for this query because of an unknown function"
Reference:
http://www.w3schools.com/xpath/xpath_functions.asp
a

NarVish21-Oct-11 0:49

XPath problem with % value

21-Oct-11 0:49

problem solved with translate function.

textNode = docRawData.SelectSingleNode("/RawData/page/text[translate(text(),\"abcdefghijklmnopqrstuvwxyz\",\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\")='" + rows[n].Trim() + "']");

NarVish18-Oct-11 0:29

18-Oct-11 0:29

Hi,

I'm trying to get the text element which contains value 1.345%, I tried as below to get the results. but the nodeList count is 0. please correct to get the correct results

XmlNodeList nodeList = rawData.SelectNodes("/RawData/page/text[.=<![CDATA[1.345%]]>");

If the value is simple text or integer, its working fine with the below code.

XmlNodeList nodeList = rawData.SelectNodes("/RawData/page/text[.='corporation'");

jschell18-Oct-11 8:52

jschell

18-Oct-11 8:52

Both examples are missing a right square backet. If your second example works though then that wouldn't be the cause. But you should still fix it.

Instead the problem is that you can't treat CDATA like that. At least googling suggests you can't.

NarVish18-Oct-11 18:39

18-Oct-11 18:39

I just forgot to put right square bracket. what to do, to make it work with the value "10.5%" instead "corporation". Thanks in advance

XmlNodeList nodeList = rawData.SelectNodes("/RawData/page/text[.='corporation']");

NarVish18-Oct-11 22:00

18-Oct-11 22:00

I found that the problem is not with "%". The values is having extra spaces as " 10.34%"

So the below expression is not working.
"/Data/page/content[.='10.34%']".

its working with the expression "/Data/page/content[.=' 10.34%']".
Please guide me to solve this issue. Thanks in advance

<Data>
<page>
<content>  10.34%</content>
</page>
</Data>

NarVish18-Oct-11 22:36

Re: How can I put condition

18-Oct-11 22:36

Issued solved with the below expression

"/Data/page/content[normalize-space(.)='10.34%']".

How can I put condition

Noor201118-Sep-11 4:23

Noor2011

18-Sep-11 4:23

Hello
I have question how can I put condition in my programming in windows phone application?
for example, if I want but code for help user when use my application the users cannot add number more than 80 in text box how I do it ?
Could you please help me !!!!
Kind regards Smile | :)

AspDotNetDev18-Sep-11 7:27

AspDotNetDev

18-Sep-11 7:27

Sounds like you are trying to add range validation to a textbox, but I doubt you are working with XML/XSL. See the forum list to find the forum appropriate for your question. Or you can ask a question in the general "Quick Answers" forum.

Martin Fowler wrote:
Any fool can write code that a computer can understand. Good programmers write code that humans can understand.

Re: How can I put condition

Morgs Morgan22-Sep-11 4:40

Morgs Morgan

22-Sep-11 4:40

You could have posted this in a C# forum, you can get an answer much quciker than here. Make sure you are in the right place before posting a question.

Try this:

try
{
   Int32 number = Int32.Parse(txtBoxId.Text);
   if(number <= 80)
   {
      //go ahead
   }
   else
   {
      //alert user they have entered a number greater than 80
   }
}
catch(Excemption e)
{
   throw new Excemption("Not a valid interger!");
}

That's a basic function you need, you can call this function on your desired textbox events e.g. on onkeypress.

Hope this helps,
Morgs

Re: How can I put condition

Noor201130-Sep-11 0:43

Noor2011

30-Sep-11 0:43

Thanks ^_^

XSLT

AndyInUK14-Sep-11 3:55

14-Sep-11 3:55

Hi, I am having a problem in displaying XML in HTML as shown below -

XML:-

HTML

<ABC>
 <DEF>
   <GHI>Heading</GHI>
   <P/> Hello, How are you? 
   <P/> I am a Developer. 
 </DEF>
</ABC>

XSLT:-

HTML

?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
  <html>
  <body>
  <h2>xml to html</h2>
  <table border="0">
    <xsl:for-each select="ABC/DEF">
    <tr>
      <td><xsl:value-of select="GHI" /></td><br/>
      <td><xsl:value-of select="." /></td>
    </tr>
    
    </xsl:for-each>
  </table>
  </body>
  </html>
</xsl:template>

</xsl:stylesheet>

OUTPUT -

Heading
HeadingHello, How are you?I am a Developer.

I want Heading to be in line 1 and then a line break and then comes paragraph. Also i want a space/line break between two paragraphs.

How to get following output instead -

Heading

Hello, How are you?
I am a Developer.

Thanks
Andyyy

Bassam Abdul-Baki15-Sep-11 4:51

Bassam Abdul-Baki

15-Sep-11 4:51

Your HTML is faulty.

XML

<table>
  <xsl:for-each select="ABC/DEF">
      <tr><td><xsl:value-of select="GHI"/></td></tr>
      <xsl:for-each select="p">
          <tr><td>
              <xsl:value-of select="."/>
          </td></tr>
      </xsl:for-each>
  </xsl:for-each>
</table>

You're using columns (TD) instead of rows (tr).

Also, change your XML to:

XML

<GHI>Heading</GHI>
<p>Hello, How are you?</p>
<p>I am a Developer.</p>

Web - BM - RSS - Math - LinkedIn

AndyInUK15-Sep-11 5:06

15-Sep-11 5:06

Thanks for your reply.

I agree with you about HTML part.

But this part of your suggested code doesn't work as it doesn't display paragraphs -

HTML

<xsl:for-each select="p">
          <tr><td>
              <xsl:value-of select="."/>
          </td></tr>
      </xsl:for-each>

The problem is, i have received XML from third party and there are hundreds of XML that needs to be displayed on webpage and everywhere they have used

HTML

<p/> 
Paragraph 1
<p/> 
Paragraph 2

So should i ask the client to produce XML correctly or is there any work around to be able to display each paragraph in separate line.

Thanks

Rhys Gravell15-Sep-11 5:27

Rhys Gravell

15-Sep-11 5:27

You need to identify the inline paragraph and break up the output based on this. I'm platying with the idea but am getting stuck around mixing up carriage returns and line feeds, grrr!

Rhys

"Technological progress is like an axe in the hands of a pathological criminal"
"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe"

Bassam Abdul-Baki15-Sep-11 5:27

Bassam Abdul-Baki

15-Sep-11 5:27

If you can get them to parse it correctly, great. Otherwise, try yours again with the right HTML code to see if it can work. I wasn't able to get it myself.

Web - BM - RSS - Math - LinkedIn

Andi Fandrich15-Sep-11 5:18

Andi Fandrich

15-Sep-11 5:18

Have you tried something like this:

HTML

<xsl:template match="*|text()">
<xsl:value-of select="."/>
</xsl:template>

And then where you have this:

HTML

<xsl:for-each select="ABC/DEF">
    <tr>
      <td><xsl:value-of select="GHI" /></td><br/>
      <td><xsl:value-of select="." /></td>
    </tr>

replace the second

HTML

<td>

line:

HTML

<td><xsl:apply-templates/></td>

Edit: sorry, fixed the formatting

AndyInUK15-Sep-11 5:28

15-Sep-11 5:28

Thanks,

Just tried it but doesn't work -

Here is the html/javascript I am using to call xml and xsl - just incase there is some problem in script instead:-

HTML

<html>
<head>
<script type="text/javascript">
function loadXMLDoc(dname)
{
if (window.XMLHttpRequest)
  {
  xhttp=new XMLHttpRequest();
  }
else
  {
  xhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xhttp.open("GET",dname,false);
xhttp.send("");
return xhttp.responseXML;
}

function displayResult()
{
	
xml=loadXMLDoc("test.xml");

xsl=loadXMLDoc("test.xsl");
// code for IE
if (window.ActiveXObject)
  {
  ex=xml.transformNode(xsl);
  document.getElementById("example").innerHTML=ex;
  }
// code for Mozilla, Firefox, Opera, etc.
else if (document.implementation && document.implementation.createDocument)
  {
  xsltProcessor=new XSLTProcessor();
  xsltProcessor.importStylesheet(xsl);
  resultDocument = xsltProcessor.transformToFragment(xml,document);
  document.getElementById("example").appendChild(resultDocument);
  }
}
</script>
</head>
<body onLoad="displayResult()">
<div id="example" />

</body>
</html>

Thanks

Rhys Gravell15-Sep-11 5:33

Rhys Gravell

15-Sep-11 5:33

The below is not perfect but is getting there. Unfortunately I need to leave the office soon but hope it helps...

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
	<html>
		<head>
			<title>Updated Template</title>
		</head>
		<body>
			<table border="0">
				<xsl:for-each select="ABC/DEF">
					<tr>
						<td><xsl:value-of select="GHI" /></td>
					</tr>
					<tr>
						<td>
							<xsl:variable name="inStr" select="."></xsl:variable>
							<xsl:variable name="outStr">
								<xsl:call-template name="template2">
									<xsl:with-param name="parameter2" select="$inStr"/>
								</xsl:call-template>
							</xsl:variable>
							<xsl:copy-of select="$outStr"/>
						</td>
					</tr>
				</xsl:for-each>
			</table>		
		</body>
	</html>
	</xsl:template>	
	<xsl:template name="template2">
		<xsl:param name="parameter2"/>
			<xsl:choose>
				<xsl:when test="contains($parameter2,'')">
					<xsl:value-of select="substring-before($parameter2,'')"/><p/>
						<xsl:call-template name="template2">
							<xsl:with-param name="parameter2">
								<xsl:value-of select="substring-after($parameter2,'')"/>
							</xsl:with-param>
						</xsl:call-template>
				</xsl:when>
				<xsl:otherwise>
					<xsl:value-of select="$parameter2"/>
				</xsl:otherwise>
			</xsl:choose>
	</xsl:template>
</xsl:stylesheet>

Rhys

"Technological progress is like an axe in the hands of a pathological criminal"
"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe"

AndyInUK15-Sep-11 5:49

15-Sep-11 5:49

Thanks goblinTech,

It's getting there - output am getting is

Heading

Heading

Hello,

How

are

you?

I

am

a

Developer.

I will keep trying.

Thanks for your help.