Jump to content

searching in xml


razstec
 Share

Recommended Posts

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>

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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>

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...