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

    Sanitize XPath for DB input


      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