razstec 0 Posted September 14, 2012 Report Share Posted September 14, 2012 Hi all, I have a xml file with this order:<SCAN><SITE>OS</SITE> <NAME>jack</NAME></SCAN> <SCAN><SITE>OD</SITE> <NAME>mary</NAME></SCAN> I need to select the name of site OD ex:if SITE=OD then=nomeelseend if Here is my code, it works fine i just need to search <%Option ExplicitResponse.Buffer = TrueDim xmlSet xml = Server.CreateObject("Microsoft.XMLDOM")xml.async = Falsexml.load (Server.MapPath("page.xml"))Dim title, heading, paragraph,paragraph2,paragraph3,paragraph4, testHTMLtitle = xml.documentElement.childNodes(0).textheading = xml.documentElement.childNodes(1).textparagraph = xml.documentElement.childNodes(2).textparagraph2 = xml.documentElement.childNodes(3).textparagraph3 = xml.documentElement.childNodes(4).textparagraph4 = xml.documentElement.childNodes(5).texttestHTML = xml.documentElement.childNodes(6).textSet xml = Nothing%><html><head><title><%= title %></title></head><body><h3 align="center"><%= heading %></h3><p align="center"><% = paragraph %></p><p align="center"><% = paragraph2 %></p><p align="center"><% = paragraph3 %></p><p align="center"><% = paragraph4 %></p><div align="center"><%= testHTML %></div></body></html> Quote Link to post Share on other sites
justsomeguy 1,135 Posted September 14, 2012 Report Share Posted September 14, 2012 There are examples here of using XPath selectors or getElementsByTagName to get a list of the XML nodes that you can loop through and process each one: http://stackoverflow.com/questions/892161/asp-classic-xml-dom You would get all of the scan nodes and then their child nodes. Quote Link to post Share on other sites
razstec 0 Posted September 17, 2012 Author Report Share Posted September 17, 2012 Thanks, but cant seem to make it work :s my xml file is this <?xml version="1.0"?>-<ExportSchema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <EXPORT_VERSION>1.1</EXPORT_VERSION> <EXPORT_DATE_TIME>2012-09-13T16:21:48.7180451+01:00</EXPORT_DATE_TIME> <EXPORT_USER>mecos</EXPORT_USER> <EXPORT_HOST>RECRI3</EXPORT_HOST> <EXPORT_INSTRUMENT_SERIAL_NUMBER>HDRSN-00502</EXPORT_INSTRUMENT_SERIAL_NUMBER> -<PATIENT> <LAST_NAME>Certification, AG</LAST_NAME> <FIRST_NAME>Case1</FIRST_NAME> <MIDDLE_NAME/> <PREFIX_NAME/> <SUFFIX_NAME/> <PAT_ID>123456789</PAT_ID> <BIRTH_DATE>1900-01-01</BIRTH_DATE> <GENDER>Other</GENDER> <OBSCURITY_LEVEL>Normal</OBSCURITY_LEVEL> <ISSUER_OF_PATIENT_ID>33166219427</ISSUER_OF_PATIENT_ID> <OTHER_PATIENT_IDS/> <CATEGORIES/> -<VISITS> -<STUDY> <VISIT_DATE>2012-06-20</VISIT_DATE> <STUDY_ID>2012062011385770</STUDY_ID> <REFERRING_PHYSICIAN/> <REQUESTING_PHYSICIAN/> <PROTOCOL>ALL SCANS</PROTOCOL> <CREATION_DATE>2012-06-20T11:39:55</CREATION_DATE> <ACCESSION_NUMBER/> <STUDY_INSTANCE_UID>1.2.276.0.75.2.2.40.33166236422.201206201138577180</STUDY_INSTANCE_UID> -<SERIES> -<SCAN> <SITE>OD</SITE> <DATE_TIME>2012-06-20T11:39:55</DATE_TIME> <PROTOCOL>Macular Cube 200x200</PROTOCOL> <SCANLENGTH>6</SCANLENGTH> <SCANTYPE>Macular Cube 200x200</SCANTYPE> <NOISE>0</NOISE> <SATURATION>0</SATURATION> <COMMENT/> <OPERATORNAME>Cirrus Operator</OPERATORNAME> <SERIES_INSTANCE_UID>1.2.276.0.75.2.2.40.33166236422.201206201139551090</SERIES_INSTANCE_UID> -<CZMOCTSETTINGS> <ZMOTORPOSITION>-29</ZMOTORPOSITION> <SCANSCALINGFACTOR_X>1</SCANSCALINGFACTOR_X> <SCANSCALINGFACTOR_Y>1</SCANSCALINGFACTOR_Y> <POLARIZATIONSLIDER>98</POLARIZATIONSLIDER> <SIGNALSTRENGTH>8</SIGNALSTRENGTH> <EYETRACKING>DISABLED</EYETRACKING> <SCANPATTERNOFFSET_X>0.029641341418027878</SCANPATTERNOFFSET_X> <SCANPATTERNOFFSET_Y>0.029641341418027878</SCANPATTERNOFFSET_Y> <SCANDEPTH>2</SCANDEPTH> </CZMOCTSETTINGS> -<CZMPATIENTALIGNMENT> <FIXATIONTARGET>0</FIXATIONTARGET> <FIXATIONBLINKRATE>0</FIXATIONBLINKRATE> <FIXATIONPOSITION_X>0</FIXATIONPOSITION_X> <FIXATIONPOSITION_Y>0</FIXATIONPOSITION_Y> <CHINRESTLOCATION_X>891</CHINRESTLOCATION_X> <CHINRESTLOCATION_Y>3228</CHINRESTLOCATION_Y> <CHINRESTLOCATION_Z>2275</CHINRESTLOCATION_Z> <OCULARLENSPOSITION>135</OCULARLENSPOSITION> </CZMPATIENTALIGNMENT> -<INSTRUMENT> <INSTRUMENT_NAME>Cirrus HD-OCT</INSTRUMENT_NAME> <STATION_NAME/> <MANUFACTURER>Carl Zeiss Meditec</MANUFACTURER> <MODEL_NUMBER>4000</MODEL_NUMBER> <SERIAL_NUMBER>4000-4550</SERIAL_NUMBER> <SOFTWARE_VERSION>5.1.1.6</SOFTWARE_VERSION> <HARDWARE_VERSION/> </INSTRUMENT> +<ANALYSIS>-+----- </SCAN> -<SCAN> <SITE>OD</SITE> <DATE_TIME>2012-06-20T11:41:18</DATE_TIME> <PROTOCOL>Optic Disc Cube 200x200</PROTOCOL> <SCANLENGTH>6</SCANLENGTH> <SCANTYPE>Optic Disc Cube 200x200</SCANTYPE> <NOISE>0</NOISE> <SATURATION>0</SATURATION> <COMMENT/> <OPERATORNAME>Cirrus Operator</OPERATORNAME> <SERIES_INSTANCE_UID>1.2.276.0.75.2.2.40.33166236422.201206201141186090</SERIES_INSTANCE_UID> -<CZMOCTSETTINGS> <ZMOTORPOSITION>-46</ZMOTORPOSITION> <SCANSCALINGFACTOR_X>1</SCANSCALINGFACTOR_X> <SCANSCALINGFACTOR_Y>1</SCANSCALINGFACTOR_Y> <POLARIZATIONSLIDER>98</POLARIZATIONSLIDER> <SIGNALSTRENGTH>10</SIGNALSTRENGTH> <EYETRACKING>DISABLED</EYETRACKING> <SCANPATTERNOFFSET_X>0.029641341418027878</SCANPATTERNOFFSET_X> <SCANPATTERNOFFSET_Y>-0.20748937129974365</SCANPATTERNOFFSET_Y> <SCANDEPTH>2</SCANDEPTH> </CZMOCTSETTINGS> -<CZMPATIENTALIGNMENT> <FIXATIONTARGET>0</FIXATIONTARGET> <FIXATIONBLINKRATE>0</FIXATIONBLINKRATE> <FIXATIONPOSITION_X>-120</FIXATIONPOSITION_X> <FIXATIONPOSITION_Y>7</FIXATIONPOSITION_Y> <CHINRESTLOCATION_X>-604</CHINRESTLOCATION_X> <CHINRESTLOCATION_Y>3368</CHINRESTLOCATION_Y> <CHINRESTLOCATION_Z>2284</CHINRESTLOCATION_Z> <OCULARLENSPOSITION>101</OCULARLENSPOSITION> </CZMPATIENTALIGNMENT> -<INSTRUMENT> <INSTRUMENT_NAME>Cirrus HD-OCT</INSTRUMENT_NAME> <STATION_NAME/> <MANUFACTURER>Carl Zeiss Meditec</MANUFACTURER> <MODEL_NUMBER>4000</MODEL_NUMBER> <SERIAL_NUMBER>4000-4550</SERIAL_NUMBER> <SOFTWARE_VERSION>5.1.1.6</SOFTWARE_VERSION> <HARDWARE_VERSION/> </INSTRUMENT> -<ANALYSIS> -<OPTIC_DISC> <DATE_TIME>2012-06-20T11:42:24</DATE_TIME> <PROTOCOL> ONH and RNFL OU Analysis </PROTOCOL> <CLOCKHOUR-1>47</CLOCKHOUR-1> <CLOCKHOUR-2>59</CLOCKHOUR-2> <CLOCKHOUR-3>116</CLOCKHOUR-3> <CLOCKHOUR-4>159</CLOCKHOUR-4> <CLOCKHOUR-5>111</CLOCKHOUR-5> <CLOCKHOUR-6>147</CLOCKHOUR-6> <CLOCKHOUR-7>86</CLOCKHOUR-7> <CLOCKHOUR-8>80</CLOCKHOUR-8> <CLOCKHOUR-9>135</CLOCKHOUR-9> <CLOCKHOUR-10>166</CLOCKHOUR-10> <CLOCKHOUR-11>141</CLOCKHOUR-11> <CLOCKHOUR-12>60</CLOCKHOUR-12> <QUADRANT_T>55</QUADRANT_T> <QUADRANT_S>129</QUADRANT_S> <QUADRANT_N>104</QUADRANT_N> <QUADRANT_I>147</QUADRANT_I> <SYMMETRY>0</SYMMETRY> <RIMAREA>1.74</RIMAREA> <DISCAREA>2.09</DISCAREA> <AVERAGE_CD_RATIO>0.41</AVERAGE_CD_RATIO> <AVERAGETHICKNESS>109</AVERAGETHICKNESS> <VERTICAL_CD_RATIO>0.4</VERTICAL_CD_RATIO> <CUPVOLUME>0.041</CUPVOLUME> <ONHCENTER_X>101</ONHCENTER_X> <ONHCENTER_Y>99</ONHCENTER_Y> </OPTIC_DISC> </ANALYSIS> </SCAN> -<SCAN> <SITE>OD</SITE> <DATE_TIME>2012-06-20T11:38:57</DATE_TIME> <PROTOCOL>Macular Cube 512x128</PROTOCOL> <SCANLENGTH>6</SCANLENGTH> <SCANTYPE>Macular Cube 512x128</SCANTYPE> <NOISE>0</NOISE> <SATURATION>0</SATURATION> <COMMENT/> <OPERATORNAME>Cirrus Operator</OPERATORNAME> <SERIES_INSTANCE_UID>1.2.276.0.75.2.2.40.33166236422.201206201138577500</SERIES_INSTANCE_UID> -<CZMOCTSETTINGS> <ZMOTORPOSITION>-29</ZMOTORPOSITION> <SCANSCALINGFACTOR_X>1</SCANSCALINGFACTOR_X> <SCANSCALINGFACTOR_Y>1</SCANSCALINGFACTOR_Y> <POLARIZATIONSLIDER>98</POLARIZATIONSLIDER> <SIGNALSTRENGTH>10</SIGNALSTRENGTH> <EYETRACKING>DISABLED</EYETRACKING> <SCANPATTERNOFFSET_X>0</SCANPATTERNOFFSET_X> <SCANPATTERNOFFSET_Y>0</SCANPATTERNOFFSET_Y> <SCANDEPTH>2</SCANDEPTH> </CZMOCTSETTINGS> -<CZMPATIENTALIGNMENT> <FIXATIONTARGET>0</FIXATIONTARGET> <FIXATIONBLINKRATE>0</FIXATIONBLINKRATE> <FIXATIONPOSITION_X>0</FIXATIONPOSITION_X> <FIXATIONPOSITION_Y>0</FIXATIONPOSITION_Y> <CHINRESTLOCATION_X>1203</CHINRESTLOCATION_X> <CHINRESTLOCATION_Y>3750</CHINRESTLOCATION_Y> <CHINRESTLOCATION_Z>2475</CHINRESTLOCATION_Z> <OCULARLENSPOSITION>135</OCULARLENSPOSITION> </CZMPATIENTALIGNMENT> -<INSTRUMENT> <INSTRUMENT_NAME>Cirrus HD-OCT</INSTRUMENT_NAME> <STATION_NAME/> <MANUFACTURER>Carl Zeiss Meditec</MANUFACTURER> <MODEL_NUMBER>4000</MODEL_NUMBER> <SERIAL_NUMBER>4000-4550</SERIAL_NUMBER> <SOFTWARE_VERSION>5.1.1.6</SOFTWARE_VERSION> <HARDWARE_VERSION/> </INSTRUMENT> -<ANALYSIS> -<MTA> <DATE_TIME>2012-06-20T11:39:38</DATE_TIME> <PROTOCOL>Macular Thickness</PROTOCOL> <Z_CENTER>286</Z_CENTER> <Z_INNERRIGHT>338</Z_INNERRIGHT> <Z_INNERSUPERIOR>334</Z_INNERSUPERIOR> <Z_INNERLEFT>344</Z_INNERLEFT> <Z_INNERINFERIOR>337</Z_INNERINFERIOR> <Z_OUTERRIGHT>312</Z_OUTERRIGHT> <Z_OUTERSUPERIOR>308</Z_OUTERSUPERIOR> <Z_OUTERLEFT>324</Z_OUTERLEFT> <Z_OUTERINFERIOR>293</Z_OUTERINFERIOR> -<FOVEA_LOCATION> <X>248</X> <Y>63</Y> </FOVEA_LOCATION> -<CENTRALSUBFIELDTHICKNESS> <ILMRPE>286</ILMRPE> <ILMRPEFIT>279</ILMRPEFIT> <RPERPEFIT>-6</RPERPEFIT> </CENTRALSUBFIELDTHICKNESS> -<CUBEVOLUME> <ILMRPE>11.1</ILMRPE> <ILMRPEFIT>11.1</ILMRPEFIT> <RPERPEFIT>0</RPERPEFIT> </CUBEVOLUME> -<CUBEAVGTHICKNESS> <ILMRPE>309</ILMRPE> <ILMRPEFIT>309</ILMRPEFIT> <RPERPEFIT>0</RPERPEFIT> </CUBEAVGTHICKNESS> </MTA> -<GCA> <DATE_TIME>2012-06-20T11:39:38</DATE_TIME> <PROTOCOL>Macular Thickness</PROTOCOL> -<FOVEA_LOCATION> <X>248</X> <Y>63</Y> </FOVEA_LOCATION> <GC_AVERAGE>86</GC_AVERAGE> <GC_MINIMUM>79</GC_MINIMUM> <GC_TEMPSUP>89</GC_TEMPSUP> <GC_SUP>81</GC_SUP> <GC_NASSUP>84</GC_NASSUP> <GC_NASINF>84</GC_NASINF> <GC_INF>85</GC_INF> <GC_TEMPINF>92</GC_TEMPINF> <RNFL_AVERAGE>31</RNFL_AVERAGE> <RNFL_MINIMUM>10</RNFL_MINIMUM> <RNFL_TEMPSUP>21</RNFL_TEMPSUP> <RNFL_SUP>32</RNFL_SUP> <RNFL_NASSUP>35</RNFL_NASSUP> <RNFL_NASINF>33</RNFL_NASINF> <RNFL_INF>37</RNFL_INF> <RNFL_TEMPINF>27</RNFL_TEMPINF> <OR_AVERAGE>136</OR_AVERAGE> <OR_MINIMUM>129</OR_MINIMUM> <OR_TEMPSUP>148</OR_TEMPSUP> <OR_SUP>141</OR_SUP> <OR_NASSUP>132</OR_NASSUP> <OR_NASINF>127</OR_NASINF> <OR_INF>132</OR_INF> <OR_TEMPINF>133</OR_TEMPINF> </GCA> </ANALYSIS> </SCAN> -<SCAN> <SITE>OS</SITE> <DATE_TIME>2012-06-20T11:44:30</DATE_TIME> <PROTOCOL>Macular Cube 200x200</PROTOCOL> <SCANLENGTH>6</SCANLENGTH> <SCANTYPE>Macular Cube 200x200</SCANTYPE> <NOISE>0</NOISE> <SATURATION>0</SATURATION> <COMMENT/> <OPERATORNAME>Cirrus Operator</OPERATORNAME> <SERIES_INSTANCE_UID>1.2.276.0.75.2.2.40.33166236422.201206201144303280</SERIES_INSTANCE_UID> -<CZMOCTSETTINGS> <ZMOTORPOSITION>-56</ZMOTORPOSITION> <SCANSCALINGFACTOR_X>1</SCANSCALINGFACTOR_X> <SCANSCALINGFACTOR_Y>1</SCANSCALINGFACTOR_Y> <POLARIZATIONSLIDER>122</POLARIZATIONSLIDER> <SIGNALSTRENGTH>9</SIGNALSTRENGTH> <EYETRACKING>DISABLED</EYETRACKING> <SCANPATTERNOFFSET_X>0.029641341418027878</SCANPATTERNOFFSET_X> <SCANPATTERNOFFSET_Y>-0.059282682836055756</SCANPATTERNOFFSET_Y> <SCANDEPTH>2</SCANDEPTH> </CZMOCTSETTINGS> -<CZMPATIENTALIGNMENT> <FIXATIONTARGET>0</FIXATIONTARGET> <FIXATIONBLINKRATE>0</FIXATIONBLINKRATE> <FIXATIONPOSITION_X>0</FIXATIONPOSITION_X> <FIXATIONPOSITION_Y>0</FIXATIONPOSITION_Y> <CHINRESTLOCATION_X>591</CHINRESTLOCATION_X> <CHINRESTLOCATION_Y>4876</CHINRESTLOCATION_Y> <CHINRESTLOCATION_Z>3394</CHINRESTLOCATION_Z> <OCULARLENSPOSITION>38</OCULARLENSPOSITION> </CZMPATIENTALIGNMENT> -<INSTRUMENT> <INSTRUMENT_NAME>Cirrus HD-OCT</INSTRUMENT_NAME> <STATION_NAME/> <MANUFACTURER>Carl Zeiss Meditec</MANUFACTURER> <MODEL_NUMBER>4000</MODEL_NUMBER> <SERIAL_NUMBER>4000-4550</SERIAL_NUMBER> <SOFTWARE_VERSION>5.1.1.6</SOFTWARE_VERSION> <HARDWARE_VERSION/> </INSTRUMENT> -<ANALYSIS> -<MTA> <DATE_TIME>2012-06-20T11:45:11</DATE_TIME> <PROTOCOL>Macular Thickness</PROTOCOL> <Z_CENTER>331</Z_CENTER> <Z_INNERRIGHT>391</Z_INNERRIGHT> <Z_INNERSUPERIOR>380</Z_INNERSUPERIOR> <Z_INNERLEFT>371</Z_INNERLEFT> <Z_INNERINFERIOR>346</Z_INNERINFERIOR> <Z_OUTERRIGHT>359</Z_OUTERRIGHT> <Z_OUTERSUPERIOR>335</Z_OUTERSUPERIOR> <Z_OUTERLEFT>332</Z_OUTERLEFT> <Z_OUTERINFERIOR>323</Z_OUTERINFERIOR> -<FOVEA_LOCATION> <X>100</X> <Y>105</Y> </FOVEA_LOCATION> -<CENTRALSUBFIELDTHICKNESS> <ILMRPE>331</ILMRPE> <ILMRPEFIT>327</ILMRPEFIT> <RPERPEFIT>-3</RPERPEFIT> </CENTRALSUBFIELDTHICKNESS> -<CUBEVOLUME> <ILMRPE>12.1</ILMRPE> <ILMRPEFIT>12.1</ILMRPEFIT> <RPERPEFIT>0</RPERPEFIT> </CUBEVOLUME> -<CUBEAVGTHICKNESS> <ILMRPE>336</ILMRPE> <ILMRPEFIT>336</ILMRPEFIT> <RPERPEFIT>0</RPERPEFIT> </CUBEAVGTHICKNESS> </MTA> -<GCA> <DATE_TIME>2012-06-20T11:45:11</DATE_TIME> <PROTOCOL>Macular Thickness</PROTOCOL> -<FOVEA_LOCATION> <X>100</X> <Y>105</Y> </FOVEA_LOCATION> <GC_AVERAGE>92</GC_AVERAGE> <GC_MINIMUM>83</GC_MINIMUM> <GC_TEMPSUP>99</GC_TEMPSUP> <GC_SUP>90</GC_SUP> <GC_NASSUP>91</GC_NASSUP> <GC_NASINF>88</GC_NASINF> <GC_INF>87</GC_INF> <GC_TEMPINF>100</GC_TEMPINF> <RNFL_AVERAGE>34</RNFL_AVERAGE> <RNFL_MINIMUM>21</RNFL_MINIMUM> <RNFL_TEMPSUP>30</RNFL_TEMPSUP> <RNFL_SUP>35</RNFL_SUP> <RNFL_NASSUP>40</RNFL_NASSUP> <RNFL_NASINF>38</RNFL_NASINF> <RNFL_INF>35</RNFL_INF> <RNFL_TEMPINF>27</RNFL_TEMPINF> <OR_AVERAGE>150</OR_AVERAGE> <OR_MINIMUM>139</OR_MINIMUM> <OR_TEMPSUP>161</OR_TEMPSUP> <OR_SUP>150</OR_SUP> <OR_NASSUP>138</OR_NASSUP> <OR_NASINF>141</OR_NASINF> <OR_INF>151</OR_INF> <OR_TEMPINF>156</OR_TEMPINF> </GCA> </ANALYSIS> </SCAN> -<SCAN> <SITE>OS</SITE> <DATE_TIME>2012-06-20T11:42:15</DATE_TIME> <PROTOCOL>Macular Cube 512x128</PROTOCOL> <SCANLENGTH>6</SCANLENGTH> <SCANTYPE>Macular Cube 512x128</SCANTYPE> <NOISE>0</NOISE> <SATURATION>0</SATURATION> <COMMENT/> <OPERATORNAME>Cirrus Operator</OPERATORNAME> <SERIES_INSTANCE_UID>1.2.276.0.75.2.2.40.33166236422.201206201142159210</SERIES_INSTANCE_UID> -<CZMOCTSETTINGS> <ZMOTORPOSITION>-56</ZMOTORPOSITION> <SCANSCALINGFACTOR_X>1</SCANSCALINGFACTOR_X> <SCANSCALINGFACTOR_Y>1</SCANSCALINGFACTOR_Y> <POLARIZATIONSLIDER>122</POLARIZATIONSLIDER> <SIGNALSTRENGTH>10</SIGNALSTRENGTH> <EYETRACKING>DISABLED</EYETRACKING> <SCANPATTERNOFFSET_X>0.029641341418027878</SCANPATTERNOFFSET_X> <SCANPATTERNOFFSET_Y>-0.059282682836055756</SCANPATTERNOFFSET_Y> <SCANDEPTH>2</SCANDEPTH> </CZMOCTSETTINGS> -<CZMPATIENTALIGNMENT> <FIXATIONTARGET>0</FIXATIONTARGET> <FIXATIONBLINKRATE>0</FIXATIONBLINKRATE> <FIXATIONPOSITION_X>0</FIXATIONPOSITION_X> <FIXATIONPOSITION_Y>0</FIXATIONPOSITION_Y> <CHINRESTLOCATION_X>591</CHINRESTLOCATION_X> <CHINRESTLOCATION_Y>4710</CHINRESTLOCATION_Y> <CHINRESTLOCATION_Z>3156</CHINRESTLOCATION_Z> <OCULARLENSPOSITION>38</OCULARLENSPOSITION> </CZMPATIENTALIGNMENT> -<INSTRUMENT> <INSTRUMENT_NAME>Cirrus HD-OCT</INSTRUMENT_NAME> <STATION_NAME/> <MANUFACTURER>Carl Zeiss Meditec</MANUFACTURER> <MODEL_NUMBER>4000</MODEL_NUMBER> <SERIAL_NUMBER>4000-4550</SERIAL_NUMBER> <SOFTWARE_VERSION>5.1.1.6</SOFTWARE_VERSION> <HARDWARE_VERSION/> </INSTRUMENT> -<ANALYSIS> -<MTA> <DATE_TIME>2012-06-20T11:43:15</DATE_TIME> <PROTOCOL>Macular Thickness</PROTOCOL> <Z_CENTER>327</Z_CENTER> <Z_INNERRIGHT>385</Z_INNERRIGHT> <Z_INNERSUPERIOR>372</Z_INNERSUPERIOR> <Z_INNERLEFT>366</Z_INNERLEFT> <Z_INNERINFERIOR>340</Z_INNERINFERIOR> <Z_OUTERRIGHT>353</Z_OUTERRIGHT> <Z_OUTERSUPERIOR>338</Z_OUTERSUPERIOR> <Z_OUTERLEFT>326</Z_OUTERLEFT> <Z_OUTERINFERIOR>311</Z_OUTERINFERIOR> -<FOVEA_LOCATION> <X>250</X> <Y>66</Y> </FOVEA_LOCATION> -<CENTRALSUBFIELDTHICKNESS> <ILMRPE>327</ILMRPE> <ILMRPEFIT>321</ILMRPEFIT> <RPERPEFIT>-5</RPERPEFIT> </CENTRALSUBFIELDTHICKNESS> -<CUBEVOLUME> <ILMRPE>11.9</ILMRPE> <ILMRPEFIT>11.9</ILMRPEFIT> <RPERPEFIT>-0</RPERPEFIT> </CUBEVOLUME> -<CUBEAVGTHICKNESS> <ILMRPE>332</ILMRPE> <ILMRPEFIT>332</ILMRPEFIT> <RPERPEFIT>0</RPERPEFIT> </CUBEAVGTHICKNESS> </MTA> -<GCA> <DATE_TIME>2012-06-20T11:43:15</DATE_TIME> <PROTOCOL>Macular Thickness</PROTOCOL> -<FOVEA_LOCATION> <X>250</X> <Y>66</Y> </FOVEA_LOCATION> <GC_AVERAGE>91</GC_AVERAGE> <GC_MINIMUM>77</GC_MINIMUM> <GC_TEMPSUP>103</GC_TEMPSUP> <GC_SUP>91</GC_SUP> <GC_NASSUP>91</GC_NASSUP> <GC_NASINF>81</GC_NASINF> <GC_INF>80</GC_INF> <GC_TEMPINF>99</GC_TEMPINF> <RNFL_AVERAGE>35</RNFL_AVERAGE> <RNFL_MINIMUM>16</RNFL_MINIMUM> <RNFL_TEMPSUP>27</RNFL_TEMPSUP> <RNFL_SUP>35</RNFL_SUP> <RNFL_NASSUP>39</RNFL_NASSUP> <RNFL_NASINF>41</RNFL_NASINF> <RNFL_INF>43</RNFL_INF> <RNFL_TEMPINF>27</RNFL_TEMPINF> <OR_AVERAGE>145</OR_AVERAGE> <OR_MINIMUM>130</OR_MINIMUM> <OR_TEMPSUP>159</OR_TEMPSUP> <OR_SUP>155</OR_SUP> <OR_NASSUP>137</OR_NASSUP> <OR_NASINF>130</OR_NASINF> <OR_INF>139</OR_INF> <OR_TEMPINF>149</OR_TEMPINF> </GCA> </ANALYSIS> </SCAN> -<SCAN> <SITE>OS</SITE> <DATE_TIME>2012-06-20T11:45:15</DATE_TIME> <PROTOCOL>Optic Disc Cube 200x200</PROTOCOL> <SCANLENGTH>6</SCANLENGTH> <SCANTYPE>Optic Disc Cube 200x200</SCANTYPE> <NOISE>0</NOISE> <SATURATION>0</SATURATION> <COMMENT/> <OPERATORNAME>Cirrus Operator</OPERATORNAME> <SERIES_INSTANCE_UID>1.2.276.0.75.2.2.40.33166236422.201206201145157650</SERIES_INSTANCE_UID> -<CZMOCTSETTINGS> <ZMOTORPOSITION>-72</ZMOTORPOSITION> <SCANSCALINGFACTOR_X>1</SCANSCALINGFACTOR_X> <SCANSCALINGFACTOR_Y>1</SCANSCALINGFACTOR_Y> <POLARIZATIONSLIDER>122</POLARIZATIONSLIDER> <SIGNALSTRENGTH>8</SIGNALSTRENGTH> <EYETRACKING>DISABLED</EYETRACKING> <SCANPATTERNOFFSET_X>0.029641341418027878</SCANPATTERNOFFSET_X> <SCANPATTERNOFFSET_Y>-0.029641341418027878</SCANPATTERNOFFSET_Y> <SCANDEPTH>2</SCANDEPTH> </CZMOCTSETTINGS> -<CZMPATIENTALIGNMENT> <FIXATIONTARGET>0</FIXATIONTARGET> <FIXATIONBLINKRATE>0</FIXATIONBLINKRATE> <FIXATIONPOSITION_X>120</FIXATIONPOSITION_X> <FIXATIONPOSITION_Y>7</FIXATIONPOSITION_Y> <CHINRESTLOCATION_X>1418</CHINRESTLOCATION_X> <CHINRESTLOCATION_Y>4705</CHINRESTLOCATION_Y> <CHINRESTLOCATION_Z>3253</CHINRESTLOCATION_Z> <OCULARLENSPOSITION>6</OCULARLENSPOSITION> </CZMPATIENTALIGNMENT> -<INSTRUMENT> <INSTRUMENT_NAME>Cirrus HD-OCT</INSTRUMENT_NAME> <STATION_NAME/> <MANUFACTURER>Carl Zeiss Meditec</MANUFACTURER> <MODEL_NUMBER>4000</MODEL_NUMBER> <SERIAL_NUMBER>4000-4550</SERIAL_NUMBER> <SOFTWARE_VERSION>5.1.1.6</SOFTWARE_VERSION> <HARDWARE_VERSION/> </INSTRUMENT> -<ANALYSIS> -<OPTIC_DISC> <DATE_TIME>2012-06-20T11:46:40</DATE_TIME> <PROTOCOL> ONH and RNFL OU Analysis </PROTOCOL> <CLOCKHOUR-1>56</CLOCKHOUR-1> <CLOCKHOUR-2>72</CLOCKHOUR-2> <CLOCKHOUR-3>142</CLOCKHOUR-3> <CLOCKHOUR-4>140</CLOCKHOUR-4> <CLOCKHOUR-5>104</CLOCKHOUR-5> <CLOCKHOUR-6>119</CLOCKHOUR-6> <CLOCKHOUR-7>79</CLOCKHOUR-7> <CLOCKHOUR-8>88</CLOCKHOUR-8> <CLOCKHOUR-9>147</CLOCKHOUR-9> <CLOCKHOUR-10>161</CLOCKHOUR-10> <CLOCKHOUR-11>118</CLOCKHOUR-11> <CLOCKHOUR-12>53</CLOCKHOUR-12> <QUADRANT_T>60</QUADRANT_T> <QUADRANT_S>129</QUADRANT_S> <QUADRANT_N>95</QUADRANT_N> <QUADRANT_I>142</QUADRANT_I> <SYMMETRY>0</SYMMETRY> <RIMAREA>1.65</RIMAREA> <DISCAREA>2.18</DISCAREA> <AVERAGE_CD_RATIO>0.48</AVERAGE_CD_RATIO> <AVERAGETHICKNESS>107</AVERAGETHICKNESS> <VERTICAL_CD_RATIO>0.47</VERTICAL_CD_RATIO> <CUPVOLUME>0.076</CUPVOLUME> <ONHCENTER_X>106</ONHCENTER_X> <ONHCENTER_Y>92</ONHCENTER_Y> </OPTIC_DISC> </ANALYSIS> </SCAN> </SERIES> </STUDY> </VISITS> </PATIENT> </ExportSchema> i nedd to select the fields by Pat_ID and SITE, the above xml is only for one Pat_ID <html><head></head><body><%Set objXML = Server.CreateObject("Microsoft.XMLDOM")objXML.Load (Server.MapPath("\") & "\MyExcel.xml")'etc'Dim nodesset nodes = objXML.selectNodes("folha")Dim aFor each node in nodes Response.Write("<ul>") Response.Write("<li>Ref: " & node.getAttribute("SCAN") & "</li>") Set a = node.selectNodes("SCAN/SITE") For each SITE in a Response.Write( "<li>Image:"& image.getAttribute("SITE") &"</li>" ) Next Response.Write( "</ul>" )Next%></body></html> Quote Link to post Share on other sites
justsomeguy 1,135 Posted September 17, 2012 Report Share Posted September 17, 2012 That code wouldn't show anything, there aren't any nodes called "folha" for it to loop through. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.