Database Lookup SQL Issue
I am trying to preform a database lookup on a value that has an ' in it. So the value is Lloyd's because of the ' , the lookup is throwing me an error. I assume this is because the SQL statement is not parsing the ' correctly? I am using Grooper version 2.8; is there a way to fix this parsing with the apostrophe with custom SQL for database lookup using the field as a variable?