Hi..!
I will be storing multiple XML documents in the database with the following structure <wrapper> <metadata> <author>John</author> <publisher>John</ publisher > </metadata> <original-content> <item> <Category>fruit</Category> <name>Apple</name> </item> <item> <Category>fruit</Category> <name>Orange</name> </item> <item> <Category>flower</Category> <name>Jasmine</name> </item> </original-content> </wrapper> The "metadata" node structure will be same for all documents but the "original-content" node structure can be different in different documents. How can we build a query which will pick all the documents that have "/metadata/author" as John and have the text "fruit" any where in the document. I also have to handle pagination in the same query. Thanks in advance. Regards, Pradeep Maddireddy
_______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
