Hi,
I am trying to use VARA_XML in PromptSet. The XML is:
<BOOK>
<name>Learning_Java</name>
<author>James_Clark</author>
<author>Ken_Follett</author>
<author>Steven_King</author>
</BOOK>
<BOOK>
<name>7_Habits</name>
<author>Steven_Covey</author>
</BOOK>
and I have a PRPT with two fields:
1- ComboBox to list all books. so the XPath/XQuery for it is book/name and it lists all books and it assigns the result to &BOOK#
2- Checkbox to show all authors of a book. the XPath/XQuery for it is book/author[name=&BOOK#] but this doesn't work even if I replace &BOOK# with static value like "7_Habits". I also tried to use ' and " around &BOOK# but I got the same result, no data returned.
Can any body help with that?
Thanks
Hesham