Jump to content

searching in xml


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 post
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 post
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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...