Connect with %LIKE% Clause

Home Forum Integrating PerfectForms Connect with %LIKE% Clause

This topic contains 1 reply, has 0 voices, and was last updated by  Anonymous 9 years, 10 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #158


    Is it possible to return results from a CONNECT command using the LIKE operator instead of a straight equality operation? For example, instead of returning all rows where a field=’SMITH’, can you return all rows where a field LIKE ‘%SMITH%’?



    Hi Ryans. This is possible and already in the application. After you setup your connection and you start configuring your action, in the send parameters, add a new parameter. The first column is the field that will be used in the ‘LIKE’ phrase. In the middle column, change the ‘=’ to ‘LIKE’ by double clicking that column, then choosing ‘LIKE’. The last column is the corresponding field in the database.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.