Pass multiple string values to a database query parameter

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:


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

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.



Login or Signup to post a comment