Subject:Xquery tag position Author:Cristian Mandelli Date:22 Jan 2010 11:41 AM Originally Posted: 22 Jan 2010 11:10 AM
Hi, I need some help with the following query:
The xml file is:
<!ELEMENT Dept (Floor+)>
<!ELEMENT Floor (Office+)>
<!ELEMENT Office (Person+)>
<!ATTLIST Office code ID #REQUIRED numPersonMax CDATA #IMPLIED >
<!ELEMENT Person (FName, LName, YearsOfService)>
<!ATTLIST Person code ID #REQUIRED >
<!ELEMENT FName PCDATA>
<!ELEMENT LName PCDATA>
QUERY:
I want to write the XQuery query asking for a list of PERSON, ordered by Name (Lname), with the indication, for each PERSON, of the floor of its office.
In particular I need help with the part about the indication of the floor of office..