How to get string length

XML to be used for our example: <FoodItems> <Item> <Name>Juice</Name> </Item> <Item> <Name>Bread</Name> </Item> <Item> <Name>Eggs</Name> </Item> <FoodItems> Now use this xml in xslt as <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <xsl:apply-templates/> </xsl:template> <xsl:template match="FoodItems"> <table border="1" style="background-color:#cccc00"> <tr> <th>Food Item</th> <th>String Length</th> </tr> <xsl:for-each select="FoodItems"> <tr> <td><xsl:value-of select="Name"/></td> <td><xsl:value-of select="string-length(Name)"/></td> </tr> </xsl:for-each> </table> </xsl:template> </xsl:stylesheet>   Output  FoodItem String Length Juice 5 Bread 5 Eggs 4 Advertisements

Read More →

Create an array in xslt

You can create any data type model you want to in xslt. To create an array, just create a variable for it. Example: <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text" omit-xml-declaration="yes"/> <xsl:variable name="array" as="element()*"> <Item>A</Item> <Item>B</Item> <Item>C</Item> </xsl:variable> <xsl:template match="/"> <xsl:value-of select="$array[2]"/> </xsl:template> </xsl:stylesheet> Output B

Read More →

How to access a variable from within xsl:for-each from outside xsl:for-each

You must have used variables in xslt, like how easy it is to use them anywhere. In the same way you can also wrap xsl: for-each with an xsl: variable. For example, the following stylesheet declares a variable EmployeeName and within the xsl: for-each it uses xsl: value-of and xsl: text. All of the text values are assigned to the variable EmployeeName, which […]

Read More →

Javascript Back Button

Just like your browser’s back button, the following script allows the user to press a button to returns the user to the previous page. Paste the following code where you want the button to appear on your page:  <FORM> <INPUT TYPE=”Button” VALUE=”Previous Page” onClick=”history.go(-1)”> </FORM> If you would rather use a link, paste the following code where you want the link to appear:  <a href=”javascript:history.back(1)”>Previous Page</a>

Read More →

SQL Query to get modified procedures

SQL Query You can use a simple query in sql server 2005 to get the modified procedures from a particular date. You just need to specify the date in the query. Try it out !!! SELECT name , modify_date FROM sys.objects WHERE type = ‘P’ AND modify_date >= ‘2011-11-24’ order by name In the same way, you can retreive the modified tables also SELECT name , modify_date FROM sys.objects WHERE type = ‘U’ AND modify_date >= ‘2011-11-24’ order by name

Read More →