Hello, CF Community:

I got this error

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.

When it executed some query like the one below:

One way that I can think of to fix it is to break “aVeryLongList” into a smaller list, but how do I do that?

But do you have any other ways to resolve it?

Thank you so much