templates and xquery

[eetele]

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

 

[Marco Kalter]

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;

 

[eetele]

thanks, works fine.