如何使用cfqueryparam和NOT NULL

Question

我有两个查询，我想在它上面使用<cfqueryparam>标记，但不确定如何对此查询执行此操作：

    <cfif isdefined("FORM.chk3g")>
        ThreeG IS NOT NULL AND
    </cfif>

    <cfif isdefined("FORM.chkpolyphonic")>
        ringtonetype like '%polyphonic%' AND
    </cfif>

Answer 1

试试这样的东西

<cfif isdefined("FORM.chk3g")>
    ThreeG IS NOT NULL AND
</cfif>

<cfif isdefined("FORM.chkpolyphonic")>
    ringtonetype like <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="%polyphonic%"> AND
</cfif>