PerfectForms Forums » Integrating PerfectForms

1. ryans
   Member

   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%'?

   Posted 2 years ago #

2. rgatson
   Member

   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.

   Posted 2 years ago #

RSS feed for this topic

Reply

You must log in or register to post.