cfml

from front i am using cfprocparam cfsqltype='varchar' to that

I don't know if there is a way to force cfprocparam to treat data as a list, but it is a feature of cfqueryparam... <https://cfdocs.org/cfqueryparam>

<https://www.bennadel.com/blog/425-coldfusion-cfqueryparam-list-attribute-is-sweeet.htm>

I'm going to guess that IDList is user-defined table-valued parameter, because that appears to be the only way it's allowed to be specificed as "readonly"

And so, the question becomes, "how do I pass a table to a stored procedure in coldfusion?"

I don't know if you can...

This article explains how to do it via the JDBC from the Java point of view: <https://docs.microsoft.com/en-us/sql/connect/jdbc/using-table-valued-parameters?view=sql-server-ver16|https://docs.microsoft.com/en-us/sql/connect/jdbc/using-table-valued-parameters?view=sql-server-ver16>

It would be cool if coldfusion supported that via passing a query object or something.  But if cfprocparam can handle this, it's not in the documentation.

i fixed it by removing IDlist and just passed a simple list and it works