且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

ColdFusion:SQL从查询中选择IN

更新时间:2022-04-24 21:59:30

cfqueryparam具有 list 属性,该属性可能会有所帮助:

cfqueryparam has a list attribute which might help:

<cfqueryparam value = "parameter value" 
        CFSQLType = "parameter type" 
        list = "yes|no" 
        maxLength = "maximum parameter length" 
        null = "yes|no" 
        scale = "number of decimal places" 
        separator = "separator character"> 
    AND/OR ...additional criteria of the WHERE clause...> 

我以前使用过它,但是不确定它是否在QoQ中. :D

I've used it before but not sure if it was in a QoQ or not. :D

ref: http://help.adobe.com /en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f6f.html