6 Replies Latest reply on Apr 7, 2009 5:02 AM by HowardTreisman

    Single Quote causing problem in XPATH

    Aditya S. Level 1
      The workflow was working fine until one of the fields had a single quote in the string and caused the update action to stall.

      Using the Execute SQL query module I am updating data in an Oracle table. The query looks like this


      SET SITE_STREET = '{$ /process_data/xfaform/object/data/xdp/datasets/data/form1/Details/site_street $}',
      SITE_STREET2 = '{$ /process_data/xfaform/object/data/xdp/datasets/data/form1/Details/site_street2 $}'

      One of the forms had the street value "Connah's Quay Deeside". I figured out that the single quote is causing the module to read it as the end of the XPATH, hence causing a "SQL command not ended properly" error.

      Any suggestions to oversome this issue.