From: xx r. <xx...@wi...> - 2010-06-15 07:17:25
|
It works!!!!!!!!!!!!!! Thank you very much > Date: Mon, 14 Jun 2010 23:36:55 +0100 > Subject: Re: [Exist-open] eXist xquery update extension > From: ad...@ex... > To: xx...@wi... > CC: da...@ex...; exi...@li... > > You have - > > <TrainerInformation> > <Identification> > <Name>Kostas Papadopoulos</Name> > </Identification> > <TrainerInformation> > > It should be - > > <TrainerInformation> > <Identification> > <Name>Kostas Papadopoulos</Name> > </Identification> > </TrainerInformation> > > I would recommend using an editor such as oXygen for writing your > XQuery and XML, it will help you to avoid such errors by highlighting > them for you. > > Cheers Adam. > > 2010/6/14 xx rvt <xx...@wi...>: > > I would like to thank you very much for your assistance. I've already used > > {} in my code, so there is no error there. > > Can you please explain to me the error in the xml file, because I cannot > > find one? > > I' m trying to fix syntactical errors but as a newbie I could use some help. > > I' m just trying to make it work. > > > > Thanks again > > > > > >> Date: Mon, 14 Jun 2010 23:21:54 +0100 > >> Subject: Re: [Exist-open] eXist xquery update extension > >> From: ad...@ex... > >> To: xx...@wi... > >> CC: da...@ex...; exi...@li... > >> > >> I would hope that you should be able to start fixing such syntactical > >> problems in your queries yourself! > >> > >> However, I just noticed in your example you sent me (which I partially > >> copied and pasted) there is an error in the XML which you are > >> inserting - > >> > >> The TrainerInformation element is not closed properly, also you may > >> need to place {} around the code I replied with as I omitted these for > >> simplicity. > >> > >> > >> > >> 2010/6/14 xx rvt <xx...@wi...>: > >> > Thank you very much for your help. I wrote the code as you showed me but > >> > I > >> > have the following error > >> > > >> > Error found > >> > > >> > err:XPST0003: Parse error: element name containing whitespace: expecting > >> > closing curly brace '}', found ' > >> > > >> > ' at line: 15 column: 15 > >> > > >> >> Date: Mon, 14 Jun 2010 22:53:26 +0100 > >> >> Subject: Re: [Exist-open] eXist xquery update extension > >> >> From: ad...@ex... > >> >> To: xx...@wi... > >> >> CC: da...@ex...; exi...@li... > >> >> > >> >> 2010/6/14 xx rvt <xx...@wi...>: > >> >> > Here you will find a part from one of my xml files > >> >> > > >> >> > <Trainers> > >> >> > <TrainerInformation> > >> >> > <Identification> > >> >> > <Name>Iordanis Giotopoulos</Name> > >> >> > <Address> > >> >> > <typename>Permanent</typename> > >> >> > <street> > >> >> > <streetname>pirgou</streetname> > >> >> > <streetnumber>12</streetnumber> > >> >> > </street> > >> >> > <city>Athens</city> > >> >> > <country>Greece</country> > >> >> > <postcode>15896</postcode> > >> >> > </Address> > >> >> > <ContactInfo> > >> >> > <telephone> > >> >> > <areacode>210</areacode> > >> >> > <telnumber>3652479</telnumber> > >> >> > </telephone> > >> >> > <mobile>698523647</mobile> > >> >> > <email>mh...@ed...</email> > >> >> > </ContactInfo> > >> >> > <Demografics> > >> >> > <gender gender="M"/> > >> >> > <date>1965-12-06</date> > >> >> > <placeofbirth>Chania</placeofbirth> > >> >> > </Demografics> > >> >> > </Identification> > >> >> > </TrainerInformation> > >> >> > </Trainers> > >> >> > > >> >> > How can I insert a new trainer? I' ve written unsuccessfully the > >> >> > following > >> >> > > >> >> > {for $trainer in doc("/db/CMS_Project/trainers.xml")//Trainers > >> >> > return > >> >> > update insert > >> >> > <TrainerInformation> > >> >> > <Identification> > >> >> > <Name>Kostas Papadopoulos</Name> > >> >> > </Identification> > >> >> > <TrainerInformation>} > >> >> > >> >> You almost have it correct but you are missing the 'into' part of the > >> >> clause, see the documentation here - > >> >> http://exist-db.org/update_ext.html#N10158 > >> >> > >> >> e.g. - > >> >> > >> >> for $trainer in doc("/db/CMS_Project/trainers.xml")//Trainers > >> >> return > >> >> update insert > >> >> <TrainerInformation> > >> >> <Identification> > >> >> <Name>Kostas Papadopoulos</Name> > >> >> </Identification> > >> >> <TrainerInformation> > >> >> into $trainer > >> >> > >> >> > >> >> Thanks > >> >> > >> >> -- > >> >> Adam Retter > >> >> > >> >> eXist Developer > >> >> { United Kingdom } > >> >> ad...@ex... > >> >> irc://irc.freenode.net/existdb > >> > > >> > ________________________________ > >> > Το email σας και πολλά ακόμα εν κινήσει. Αποκτήστε δωρεάν το Windows > >> > Live > >> > Hotmail. Εγγραφείτε τώρα. > >> > >> > >> > >> -- > >> Adam Retter > >> > >> eXist Developer > >> { United Kingdom } > >> ad...@ex... > >> irc://irc.freenode.net/existdb > > > > ________________________________ > > Hotmail: Αξιόπιστο email με την ισχυρή προστασία ενάντια στην ανεπιθύμητη > > αλληλογραφία που παρέχει η Microsoft. Εγγραφείτε τώρα. > > > > -- > Adam Retter > > eXist Developer > { United Kingdom } > ad...@ex... > irc://irc.freenode.net/existdb _________________________________________________________________ Hotmail: Δωρεάν, αξιόπιστη και αποτελεσματική υπηρεσία email. https://signup.live.com/signup.aspx?id=60969 |