Pass multiple string values to a database query parameter : InfoSol Help Desk

How can we help you today?

Pass multiple string values to a database query parameter

Bryan Baca

started a topic over 5 years ago

In this example, a SQL query has a parameter:

SELECT * FROM table1

WHERE state IN @state

The string value provided to the parameter must be wrapped in quotes:

'California'

To pass multiple, delimited values, you must insert a break character (!) so InfoBurst will pass the quotes with the query:

!'California','New York'

1 Comment

Indu Prakash

said over 5 years ago

Hi Bryan

When I use this method to pass multiple parameter to the query and burst the result, I get multiple outputs created. How do I get the result in one sungle spreadsheet for both the parameter values? I suspect it has to be the Multipass option checkbox but then it is grayed out for me to change it as well.

Regards

Indu