Skip to main content
Nintex Community Menu Bar

How do I specify parameter within an ADO Query

  • January 31, 2015
  • 1 reply
  • 12 views



 

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

Forum|alt.badge.img+4
  • February 7, 2018

Is it possible to pass Multiple parameter values? 

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

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