First post: I’m hoping someone more GF knowledgeable can point me in the right direction to solve an issue that’s cropped up.
I have a simple form that takes an input text string to search a database table of movies for that string to be part of the movie’s title. It then passes that input using a confirmation redirect in a querystring to a page that uses the WP Data Access plugin to display the results. The querystring takes the form ?wpda_search_column_Title=%Potter% : the result of that is it searches the database using a SQL SELECT… WHERE Title LIKE ‘%Potter%.
All was working fine until recently. However in the latest WPDA release they improved their security (it now uses decodeURIComponent and thus requires the % sign to be encoded as the escaped %25). So I went to my form and tried to change the querystring to replace the ‘%’s with ‘%25’s. But GF rejects that formatting with a message “The text you have entered is not valid. For security reasons, some characters are not allowed”.
Ironically this means the combined efforts of GF and WPDA to maintain security have resulted in them no longer playing nice together. I’d say neither party is wrong in what they are doing but the end result is an incompatibility.
I am speaking to the WPDA development team as well as GF to see if a solution can be devised. My question to the GF end is if anyone can suggest a way to pass a %25 in a querystring?
You can view the form in question at https://movies.blewis.com.au (note there are four forms on the page, Title Search is the simplest hence my using that as the example).
Thanks in Advance for all suggestions.