在ColdFusion cfscript查询LIKE语句中是否使用通配符'％'？ [英] Wildcard, '%', within ColdFusion cfscript query LIKE statement?

问题描述

是否可以在ColdFusion cfscript查询的SQL LIKE语句中使用通配符？

Is it possible to use a wildcard in a SQL LIKE statement within a ColdFusion cfscript query?

一个不起作用的示例：

local.q = new Query(); 
local.q.setDatasource(variables.dsn);
local.q.addParam(name='lastname', value='%' & arguments.lastname,     cfsqltype="cf_sql_varchar");
local.qString = 'SELECT name FROM users WHERE lastname LIKE :lastname';
local.q.setSQL(local.qString);
local.result = local.q.execute().getResult();

我也尝试了以下方法，但没有用：

I also tried these, which didn't work:

local.qString = 'SELECT name FROM users WHERE lastname LIKE %:lastname';
local.qString = "SELECT name FROM users WHERE lastname LIKE '%:lastname'";

更新：

我正在使用MS SQL Server 2008。

I am using MS SQL Server 2008.

该查询在SQL Server Mgmt Studio中运行良好...我认为这与如何格式化在cfscript标签中进行查询？

The query works fine within SQL Server Mgmt Studio... I think it has something to do with how to format the query within cfscript tags?

推荐答案

是的，有可能。您在参数中进行了设置，这是正确的。我不确定为什么它不能与您一起使用。

Yes, it is possible. You're setting it in the param, which is correct. I'm not sure why it's not working with you.

我做到了以下几点，并且有效。

I did the following and it worked.

var qryArgsCol = {};            
qryArgsCol.datasource = variables.datasource;
qryArgsCol.SQL = "                      
                SELECT ID
                FROM Users
                WHERE LastName LIKE :searchStringParam
                ";
var qryGetID = new query(argumentCollection=qryArgsCol);
qryGetID.addParam(name="searchStringParam", value="%" & searchString, cfsqltype="cf_sql_varchar");
qryGetIDResult = qryGetID.execute().getResult();

这篇关于在ColdFusion cfscript查询LIKE语句中是否使用通配符'％'？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！