How do I specify parameter within an ADO Query

  • 31 January 2015
  • 1 reply
  • 5 views
K


 

Symptoms


How do I specify parameter within an ADO Query
 

Diagnoses


How do I specify parameter within an ADO Query
 

Resolution

To specify a parameter within an ADO query, please use the 'HAVING' statement.
Example:

SELECT * FROM [Smartobject].[Method] HAVING [Parameter] = [Value]

SELECT * FROM Book.List HAVING p_Name = 'Lord of the Ring'




 

1 reply

M
Badge +4

Is it possible to pass Multiple parameter values? 

I need to pass  Parameter1 Name in ('test','test1')

and parameter 2 date =('02/07/2018')

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings