ASP with XML

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Tim:.

    ASP with XML

    Hi Can someone explain to me how I can do the following

    I have an xml document that has a START and FINISH node. These nodes contain start and finish dates for a project. I would like to convert the dates so they are shown as a value instead of a date

    E.G:
    Start = 2004-04-05T08:00:0
    Finish = 2004-04-07T17:00:0

    So what I want to do is convert the start to finish to represent a numeric value where 1 day = 16 and 12 hours = 8, how do I go about doing this and then submiting the value to an xsl document

    At the moment I have a xml document with all the data, and xslt document and an asp document which creates the XHTML code on the server

    ....::: AS
    <%@LANGUAGE="VB SCRIPT" CODEPAGE="1252" %><
    'Load XM
    set xml = Server.CreateOb ject("Microsoft .XMLDOM"
    xml.async = fals
    xml.load(Server .MapPath("Proje ctTEST.xml")

    'Load XS
    set xsl = Server.CreateOb ject("Microsoft .XMLDOM"
    xsl.async = fals
    xsl.load(Server .MapPath("GantC hartView.xsl")

    'Transform fil
    Response.Write( xml.transformNo de(xsl)
    %

    ....:: XM

    <Project><Name> Test.xml</Name><Title>Vie w</Title><Task><ID >1</ID><Start>2004-04-05T08:00:00</Start><Finish>2 004-04-07T17:00:00</Finish></Task></Project

    ...:: XSL

    Need the value for a day here

    EG from above 3 Working Days: Value = 4

    Thanks for any advice

Working...