Passing a Table Valued parameter to a stored procedure

Posted by cf_PhillipSenn on Stack Overflow See other posts from Stack Overflow or by cf_PhillipSenn
Published on 2010-04-21T14:35:19Z Indexed on 2010/04/24 14:33 UTC
Read the original article Hit count: 403

Filed under:

coldfusion

Here's an example of how to use table-valued parameters in a SQL Server 2008 stored procedure using .NET.

And here's the list of parameter types in CF9.

Q: Is it possible for ColdFusion to pass a table-valued parameter to a Microsoft SQL Server 2008 stored procedure?

Related posts about coldfusion

Coldfusion autorestart

as seen on Server Fault - Search for 'Server Fault'
Coldfusion is automatically restarting, a lot. It comes in waves, everything seems fine for a while then the server struggles for a few minutes, restarts a lot then settles down again. I have Fusion Reactor installed, but when CF goes down FR stops logging so it's not really helping. Looking through… >>> More
How do I change ColdFusion Help to show ColdFusion 8 Documentation, instead of ColdFusion 9 Document

as seen on Stack Overflow - Search for 'Stack Overflow'
I love ColdFusion Builder. But I don't like that the help only has CF9 Documentation. Is there any way to change this to have ColdFusion 8 Documenation? >>> More
Moving from ColdFusion 8 to ColdFusion 10 - Migration Fails

as seen on Server Fault - Search for 'Server Fault'
After having made several attempts to migrate from a ColdFusion 8 Standard server to a ColdFusion 10 Standard server, it feels like I am "almost" there. I'm using the 64 bit installer from Adobe's website. I'm using a Windows Server 2008 (64 bit) server with IIS 7.0. The installation itself goes… >>> More
Unauthorized Sharepoint WSDL from Coldfusion 8

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I solve the error: Unable to read WSDL from URL: https://workflowtest.site.edu/_vti_bin/Lists.asmx?WSDL. Error: 401 Unauthorized. I can successfully view the WSDL from the browser using the same user account. I'm not sure which authentication is being used (Basic or Integrated). How… >>> More
ColdFusion Server crash after thousands of HTTP requests

as seen on Server Fault - Search for 'Server Fault'
We are running ColdFusion 8 on a windows server 2003 VPS with an API that exposes student records to a partner API through a connector. Our API returns around 50k student records serialized in XML format pretty seamlessly. My question originates when something very frightening happened today when… >>> More

Developer IT

Passing a Table Valued parameter to a stored procedure - Developer IT

Passing a Table Valued parameter to a stored procedure

coldfusion

Related posts about coldfusion

Coldfusion autorestart

How do I change ColdFusion Help to show ColdFusion 8 Documentation, instead of ColdFusion 9 Document

Moving from ColdFusion 8 to ColdFusion 10 - Migration Fails

Unauthorized Sharepoint WSDL from Coldfusion 8

ColdFusion Server crash after thousands of HTTP requests

Categories cloud