missed sending to list... -- Jens Erat [phone]: tel:+49-151-56961126 [mail]: mailto:email@jenserat.de [jabber]: xmpp:jabber@jenserat.de [web]: http://www.jenserat.de PGP: 350E D9B6 9ADC 2DED F5F2 8549 CBC2 613C D745 722B Anfang der weitergeleiteten Nachricht:

Von: Jens Erat <jens.erat@uni-konstanz.de> Betreff: Aw: [basex-talk] Error while storing "<" and "<=" in DB Datum: 15. Mai 2013 11:40:29 MESZ An: John Best <johnbest5673@gmail.com>

Hi John,

as I understand your query you want to store the XQuery code in line three as text content in an XML database.

In Text nodes, the characters `<`, `>` and `&` must be escaped as entities. Either you write

for $x in /Docs/Doc where $x/Title[Desc/@name='IT' and Year >= '2010' and Year <= '2013']

or you mark the whole Query as CDATA (probably to be preferred):

for $x in Searches return insert node <SH><Id>0</Id><Date>20130515 14:05:44</Date><Query><![CDATA[ for $x in /Docs/Doc where $x/Title[Desc/@name='IT' and Year >= '2010' and Year <= '2013'] ]]></Query></SH> as last into $x

Regards from Lake Constance, Germany Jens

-- Jens Erat

[phone]: tel:+49-151-56961126 [mail]: mailto:email@jenserat.de [jabber]: xmpp:jabber@jenserat.de [web]: http://www.jenserat.de

PGP: 350E D9B6 9ADC 2DED F5F2 8549 CBC2 613C D745 722B

Am 15.05.2013 um 10:57 schrieb John Best <johnbest5673@gmail.com>:

...

Hi there,

I am trying to save the generated queries in database, to have a Search History.

Some of my queries have "where" conditions with < (less than) and <= (less than equal to operators.

This is the insert query -

for $x in doc('SHIST')/Searches return insert node <SH><Id>0</Id><Date>20130515 14:05:44</Date><Query> for $x in doc('Docs')/Docs/Doc where$x/Title[Desc/@name='IT' and Year >= '2010' and Year <= '2013'] </Query></SH> as last into $x

I am getting error "Expecting tag name, '<=' found

Any workaround for the same...??

-- Have a nice day JBest

_______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk