I needs some assistance with my XPath expression. The XPath expression
noted in the <cf_xmlquery> works fine - the probem is that I have to run a
seperate query for each value (10 values x 11 prod_name). There must be a
way around this - please provide input on how I need to change the XPath
expression to obtain all value within this record.
Thanks,
Jerry Travioli
<!--- output.cfm --->
<cf_xmlquery
xmldata = "avgs.xml"
datatype = "file"
name = "Rate30"
xpath = "//Record[prod_name='30 yr fixed mtg']/rate"
debug = "yes">
<!--- avgs.xml --->
<Report>
:
:
<Record>
<state>ZZ</state><prod_type>M</prod_type><prod_no>1</prod_no><prod_name>30
yr fixed mtg
</prod_name><rate>6.8</rate><apr_yld>7.04</apr_yld><rate_diff>D</rate_diff><
b1wkrate>6.82</b1wkrate><b1wkapryld>7.06</b1wkapryld><b1morate>6.81</b1morat
e><b1moapryld>7.04</b1moapryld><b6morate>6.66</b6morate><b6moapryld>6.85</b6
moapryld><thisday>7/11/01</thisday>
</Record>
:
:
</Report>
-----------------------+
cf-xml mailing list
[EMAIL PROTECTED]
http://torchbox.com/xml
