load table with data from xml file

F

faamugol

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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,769
Messages
2,569,580
Members
45,055
Latest member
SlimSparkKetoACVReview

Latest Threads

Top