Print Thread
templates and xquery
#56832 07/28/17 01:23 PM
Joined: Apr 2013
Posts: 34
E
eetele Offline OP
Member
OP Offline
Member
E
Joined: Apr 2013
Posts: 34
hi,
saved a template, where is a query:
select xmlquery( 'fn:node-name(for $d in //*[self::szilva or self::korte] return $d)' passing d.xml returning content).getstringval() as elco_mail
from sq_base d;

when im opening it, it seems the templating engine offers me to replace the part with [ ].
is there a way to avoid this? some escaping or so..
thanks

Re: templates and xquery
eetele #56836 07/29/17 09:52 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
To escape [var] substitution you can use [[var]] instead:

select xmlquery( 'fn:node-name(for $d in //*[[self::szilva or self::korte]] return $d)' passing d.xml returning content).getstringval() as elco_mail
from sq_base d;


Marco Kalter
Allround Automations
Re: templates and xquery
Marco Kalter #56842 07/31/17 07:48 AM
Joined: Apr 2013
Posts: 34
E
eetele Offline OP
Member
OP Offline
Member
E
Joined: Apr 2013
Posts: 34
thanks, works fine.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.041s Queries: 14 (0.012s) Memory: 2.5045 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-05-18 20:45:18 UTC
Valid HTML 5 and Valid CSS