可复制的Coldfusion SQL异常 [英] Copyable Coldfusion SQL Exception

问题描述

每当CF抛出错误，我都会收到一封包含所有例外信息的电子邮件。每次它涉及数据库错误，我得到SQL，WHERE和QueryError信息，这是很好的。

Whenever CF throws an error I get an email with all the exception information. Every time it involves a database error I get the SQL, WHERE and QueryError information, which is nice.

SQL  SELECT FooID FROM FooTable WHERE FooID = (param 1)
WHERE    (param 1) = [type='IN', class='java.lang.Integer', value='47', sqltype='CF_SQL_INTEGER'] 
Error   [Macromedia][SQLServer JDBC Driver][SQLServer]Insufficient clearance to break temporal directive.

然而，如果它是一个特定的多个cfqueryparams的长时间查询，搜索和替换params通过MSSQL来运行同一个查询。我一直希望能够以编程方式包含可复制的查询行，以便我可以通过查询窗口快速运行它。

However if it's a particular long winded query with multiple cfqueryparams, it becomes cumbersome to search for and replace the params to run that same query through MSSQL. I've always wanted to be able to programmatically include a copyable query line so that I can quickly run it through a query window.

推荐答案

ColdFusion Muse具有此关于查询参数的博客帖子。

The ColdFusion Muse has this blog post about query params.

这篇关于可复制的Coldfusion SQL异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！