1 Reply Latest reply on Jun 1, 2010 6:11 AM by Jasmin Charbonneau

    Sanitize XPath for DB input

    azathoth_ Level 1

      Hello all

       

      In my orchestration I have a Call Stored Procedure task that accepts a bunch of XPath expressions as its parameters (obviously)

       

      The problem arises when the values contain apostrophes/single quotes like : ' insertion fails because they cause syntax errors on the DBMS

       

      Is there an effectve way of "escaping" the apostrophes? I'm trying to use XSLT but the truth is I'm not an expert on that

       

      What are the best practices for SQL sanitization using LiveCycle?

       

      Thanks for your help