Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters

January 18, 2025

pham_mn Follow

Summary

SQL error

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:

SELECT aColumn

FROM aTable

AND aId IN (#aVeryLongList#”)

</cfquery>

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

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:

SELECT aColumn

FROM aTable

AND aId IN (#aVeryLongList#”)

</cfquery>

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

Advanced

application performance

discussion

performance

(0)

Comments

(1)

pham_mn Follow

You must be logged in to post a comment.

tomc88740733

2025-01-28 08:34:13

tomc88740733

2025-01-28 08:34:13

You should be using CFQUERYPARAM with LIST=”TRUE”.

Any help ?

()