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
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