Escaping apostrophe before running DB Lookup

Use the attached Template to escape single quote (apostrophe) coming in a value and use this in a variable. And insert this variable in the Where clause.

If value is string enclose the variable in single quotes in the Where condition.

Go to Mapper and click on 'XSL Template' tab and there use the Global option and create the template by copy pasting the content. Make sure the template and parameter name are same that are defined in the template code.

Now create a local variable on the field where you want to apply the Lookup condition. In the variable vale pull in this template and inside it provide the source field name. Save the variable.

Now in the Textual Tab where you have the Lookup condition, put this variable in the Where condition.

Have more questions? Submit a request

0 Comments

Article is closed for comments.