From: xx r. <xx...@wi...> - 2010-06-14 22:30:27
|
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. https://signup.live.com/signup.aspx?id=60969 |