using query in XML file

[aa1232]

Hi Folks,

Is it possible to use "select field from table where field = @par" in XML in order to populate my dropdown control. I have an xml file (below) i want to use select query to select test_name where Product_name = something. is it possible.


<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<XML_TEST_NAME>
<PRODUCT_NAME>ALx</PRODUCT_NAME>
<TEST_NAME>NBQ SEx</TEST_NAME>
</XML_TEST_NAME>
<XML_TEST_NAME>
<PRODUCT_NAME>ALxxA</PRODUCT_NAME>
<TEST_NAME>NBQ SExxxA</TEST_NAME>
</XML_TEST_NAME>
</NewDataSet>

 

[tsuji]

[tt]let $doc:=doc("[green]pathtoyoursourc.xml[/green]")
for $v in $doc//XML_TEST_NAME
where $v/PRODUCT_NAME="ALxxA"
return data($v/TEST_NAME)
[/tt]