当我尝试在ColdFusion中执行存储过程时，不是所有的信息都返回 [英] When I try to execute the stored procedure in ColdFusion, then not all of the information is returned

问题描述

当我尝试在ColdFusion中执行存储过程时，不会返回所有信息。

• 我正在运行ColdFusion 9.0.1 w / Hot Fix 2。


• 我使用SQL Server 2008 r2。


• 我仅限于存储过程调用。


• 我可以在SQL Server Management Studio中执行存储过程，以单个记录作为变量或select语句返回。


• ColdFusion从结果集返回的数据为32000个字符


• ColdFusion从cf_sql_varchar返回的数据长度为4000个字符。


• ColdFusion从cf_sql_longvarchar返回的数据长度为4000个字符。


• ColdFusion从cf_sql_text返回的数据长度为4000个字符。


• ColdFusion从cf_sql_text返回的数据长度为4000个字符。任何关于如何使用ColdFusion存储过程调用获取我的数据的想法？
  h2_lin>解决方案

  尝试：

  
  
  

  1）登录您的ColdFusion管理员

  
  
  

  2）点击导航菜单上的数据源（在数据与服务下）

  
  
  

  3）点击您的数据源

  
  
  

  4）点击页面底部的显示高级设置按钮

  
  
  

  5）选中CLOB

  
  
  

  我打算在您的服务器上的缓冲区值在下面的框中是4000。

  
  
  

  默认值是64000，这可能是一个线索比我这里的基础。

  
  

  When I try to execute the stored procedure in ColdFusion, then not all of the information is returned.

  • I'm running ColdFusion 9.0.1 w/ Hot Fix 2.
  • I'm working with SQL Server 2008 r2.
  • I'm limited to stored procedure calls.
  • I can execute a stored procedure in SQL Server Management Studio to return a single record either in as a variable or as a select statement. The complete record is returned.
  • The data stored in the database is 36539 characters long.
  • The data returned by ColdFusion from a resultset is 32000 characters long.
  • The data returned by ColdFusion from a cf_sql_varchar is 4000 characters long.
  • The data returned by ColdFusion from a cf_sql_longvarchar is 4000 characters long.
  • The data returned by ColdFusion from a cf_sql_text is 4000 characters long.
  • The data returned by ColdFusion from a cf_sql_text is 4000 characters long.

  Any ideas on how I can get my data with a ColdFusion stored procedure call?

  解决方案

  Try this:

  1) Log in to your ColdFusion administrator

  2) Click on "Data Sources" on the navigation menu (under Data & Services)

  3) Click on your data source

  4) Click on the "Show Advanced Settings" button at the bottom of the page

  5) Check the box next to "CLOB"

  I would bet the "Buffer" values in the next boxes are "4000" on your server.

  The default is "64000", which may be a clue than I am off base here.

  这篇关于当我尝试在ColdFusion中执行存储过程时，不是所有的信息都返回的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！