I am using Tom Dyson's Cold Fusion custom tag 'xmlquery' and need some
assistance with the syntax.
[source .xml file content]
<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.76</rate>
<apr_yld>6.99</apr_yld>
<rate_diff>S</rate_diff>
<b1wkrate>6.76</b1wkrate>
<b1wkapryld>6.99</b1wkapryld>
<b1morate>6.96</b1morate>
<b1moapryld>7.18</b1moapryld>
<b6morate>6.85</b6morate>
<b6moapryld>7.05</b6moapryld>
<thisday>6/28/01</thisday>
</Record>
:
:
</Report>
[ end ]
[cfml template code]
<cf_xmlquery
xmldata = "rates.xml"
datatype = "file"
name = "GetRates"
xpath = "//Record[@prod_name='30 yr fixed mtg']"
debug = "yes">
<h1>Get 30 yr Fixed</h1>
<cfoutput query = "GetRates">
rate: #rate#<br>
rate_diff: #rate_diff#<br>
</cfoutput>
[ end ]
[error message]
Sorry, there are no results for query 'GetRates'.
This query will not be available to the calling template.
cf_xmlquery C torchbox.com 2001
[ end ]
It appear that my problem is the syntax {xpath = "//Record[@prod_name='30 yr
fixed mtg']"}, could someone give me some pointers on the proper syntax to
search and return from the query all of the data associated with the
'prod_name' "30 yr fixed mtg".
I would appreciate input and assistance. Thank you in advance.
Best regards,
Jerry Travioli
-----------------------+
cf-xml mailing list
[EMAIL PROTECTED]
http://torchbox.com/xml
