load table with data from xml file

Discussion in 'ASP .Net Web Controls' started by faamugol, Mar 4, 2004.

  1. faamugol

    faamugol Guest

    Hi,
    I have data in the following xml file mydata.xml

    <DATA
    <RECORD datevalue="01.01.2003 10:00" mwh="0,001" />
    <RECORD datevalue="01.01.2003 10:05" mwh="0,002" />
    <RECORD datevalue="01.01.2003 10:10" mwh="0,001" />
    <RECORD datevalue="01.01.2003 10:15" mwh="0,003" />
    <RECORD datevalue="01.01.2003 10:20" mwh="0,001" />
    </DATA

    Set SourceObj
    Server.CreateObject("MSXML2.DOMDocument.4.0"
    SourceObj.async = fals
    SourceObj.setProperty "SelectionLanguage"
    "XPath
    filename = Server.MapPath("mydata.xml"

    SourceObj.load(filename

    set ar1 = SourceObj.documentElement.selectNodes

    ("//RECORD/@datevalue"
    set ar2
    SourceObj.documentElement.selectNodes("//RECORD/@mwh"

    I want to do the following

    To store in my two tables tab1 and tab2 with data from ar1 and ar
    without using a LOO
    I use the JOIN functio
    tab1 = Join(ar1, ','
    tab2 = Join(ar2, ',') but dont wor

    Can any one give me a idea or some links do it without

    Thand you for your suggestio
     
    faamugol, Mar 4, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. David Williams
    Replies:
    2
    Views:
    1,184
    Jacob Yang [MSFT]
    Aug 12, 2003
  2. Rio
    Replies:
    4
    Views:
    1,250
  3. David Shen

    Problem with xml.load & xsl.load in JSP

    David Shen, Aug 28, 2003, in forum: Javascript
    Replies:
    0
    Views:
    127
    David Shen
    Aug 28, 2003
  4. Erik Wasser
    Replies:
    5
    Views:
    531
    Peter J. Holzer
    Mar 5, 2006
  5. Replies:
    5
    Views:
    111
    Chris Angelico
    May 14, 2014
Loading...

Share This Page