razstec Posted September 14, 2012 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> Link to comment Share on other sites More sharing options...
justsomeguy Posted September 14, 2012 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. Link to comment Share on other sites More sharing options...
razstec Posted September 17, 2012 Author 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> Link to comment Share on other sites More sharing options...
justsomeguy Posted September 17, 2012 Share Posted September 17, 2012 That code wouldn't show anything, there aren't any nodes called "folha" for it to loop through. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now