XML / XSL

richiemac wrote:

Hope this clears up the confusion.

richiemac wrote:

that I'm trying to concatenate into the query string that is read from the config.

richiemac wrote:

I have an XML file with a number of elements, one of which is,

select * from trainarrivals where ActiveFlag = 1 and DueTime between ('@DTStart') and ('@DTEnd')

Tomi87 wrote:

There are multiple root elements

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
   xmlns:msxsl="urn:schemas-microsoft-com:xslt"
   xmlns:date-time="http://mycompany.com/mynamespace"
   version="1.0" 
   exclude-result-prefixes="date-time msxsl">

   ...
      <xsl:value-of select="date-time:GetMyDate()"/>
   ...
	
   <msxsl:script language="JavaScript" implements-prefix="date-time">
      <![CDATA[
         function GetMyDate()
         {
            var myDate = new Date()
            var y = myDate.getFullYear()
            var m = EnsureLength(myDate.getMonth() + 1, 2)
            var d = EnsureLength(myDate.getDate(), 2)
            var h = EnsureLength(myDate.getHours(), 2)
            var min = EnsureLength(myDate.getMinutes(), 2)
            var s = EnsureLength(myDate.getSeconds(), 2)
            var mil = EnsureLength(myDate.getMilliseconds(), 3)
            return y + "-" + m + "-" + d + "-" + h + min + s + mil
         }
         function EnsureLength(s,n)
         {
            s = new String(s)
            while (s.length < n)
               s = "0" + s;
            return s;
         }
         ]]>
    </msxsl:script>
</xsl:stylesheet>

XmlDocument doc = new XmlDocument();
doc.Load("file_path.xml");

//add new data
XmlElement element = doc.CreateElement("NewElement");
element.InnerText = "test data";
doc.DocumentElement.AppendChild(element);

doc.Save("file_path.xml");