Recent content by JJR

If you want better performance (not looping through each node): <xsl:value-of select="/xml/contents/content[@typeid=1][3]"/>

<xsl:stylesheet version=&quot;1.0&quot; xmlns:xsl=&quot;http://www.w3.org/1999/XSL/Transform&quot;> <xsl:param name=&quot;search&quot;>default value</xsl:param> <xsl:for-each select=&quot;artist/title&quot;> <xsl:sort select=&quot;artist&quot; /> <xsl:if test=&quot;artist = $search&quot;>...

Use the winzip command line add on. It's free downloadable from www.winzip.com. As far as I know, there's no free COM add-in. Jordi Reineman

&quot;As everything *should* have been using systems settings it should have gone fine&quot; That's not entirely true. Since you add a date to a node and Microsoft always tries to 'help' you, it is assumed that you try to add a node of the type 'Date'. By design of the W3C a Date node in XML...

Hi Muddmuse, I've had simular problems reading an XSD. Code that worked fine with the 3.0 parser didn't work with the 4.0 parser. I still haven't found the solution but I think it has something to do with the default query language MS uses with the 4.0 parser. So try setting the...

Hi Hameed, Variables in XSL can not be reassigned, thus meaning that once you've assigned a value to a variable, you can't change it anymore. Try to use the sum() function instead. Good luck! Jordi Reineman

Can this be done via command lines, .net or anything else?? All of the above! It all depends on the proces in which the transformation has to take place (Internet, Client-server app, etc) and what programming language you favor (or which language the business tells you to use ;-) ) Browse this...

Hi Glenn, Are you sure your code doesn't recognize the XPath function contains? What is XMLDocument for kind of object? I guess it's an XMLDomDocument object. What I'm interested in is what version of IE you are using and what verson of XMLDomDocument you're instanciating. If you use the...

Hi Calvin, Use Sourcesafe, the source code manager from MS. Included with Visual Studio enterprise edition. Take a look here http://msdn.microsoft.com/ssafe/prodinfo/qa.asp Jordi Reineman

Hi, Use Print #1, &quot;The data I need to see in the Log&quot;; Tab(1) Jordi Reineman

Hi all, Not been here for a while.... Ok, you can open a excel sheet like it's a database and transform it to XML using the following VB code: Dim oCon As ADODB.Connection Dim sSql As String Dim oRs As ADODB.Recordset Dim oXml As MSXML2.DOMDocument40 Set oCon = New ADODB.Connection...

Hi Jacques, Download the Microsoft XML Core Services (MSXML) 4.0 from http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en Then take a look at the DomDocument object. Among others, this object allows you to create xml documents from...

Hi Ladyhawk, The xs:all element is used in schema's if you want to indicate that the group of nodes below this element can appear in any order (e.g. if you use xs:sequence the elements must appear in the exact same order in your xml file) Jordi Reineman

Hi crowsario, Which version of the Microsoft xml parser are you relying on? It looks like you're using a very old version of the parser, which used a working draft version of the xslt specifications and is missing a lot of functionality. Jordi Reineman

Hi ashridharan, Try using: <xsl:for-each select=&quot;ROOT\PARENT[not(SOMENODE = &quot;123&quot;)]&quot;> <xsl:value-of select=&quot;@Id&quot;/> </xsl:for-each> Good luck! Jordi Reineman