#12004/11/5 15:23:57
我用quotedvaluelist()得到
'E1BCB8','5A93B2','1CB20D','05C9FB','89BC5C','AE76F2','381497','40E6C5','F1B437','9BFE2F','84A82A','A9C01B','762E7C','D26724','DBE037','968656','A08857','5DC192','606A52','D97696','71FCF8','375898','CCA72C','00113F','2E4C42'
并把他存放在名叫classd的变量中
进行用SQLSERVER查询
<cfquery name="baseclass" datasource="#DB#">
select * from CLPtable where classifyID in (#classd#)
</cfquery>
<cfoutput>#baseclass.recordcount#</cfoutput>
运行后得到错识信息
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]第 1 行: 'E1BCB8' 附近有语法错误。
原直接写
<cfquery name="baseclass" datasource="#DB#">
select * from CLPtable where classifyID in ('E1BCB8','5A93B2','1CB20D','05C9FB','89BC5C','AE76F2','381497','40E6C5','F1B437','9BFE2F','84A82A','A9C01B','762E7C','D26724','DBE037','968656','A08857','5DC192','606A52','D97696','71FCF8','375898','CCA72C','00113F','2E4C42')
</cfquery>
<cfoutput>#baseclass.recordcount#</cfoutput>
的话就没有问题!
不知道如何解决掉,高手帮忙啊