How to use cfqueryparam and NOT NULL

Question

I have 2 queries and I want to use the <cfqueryparam> tag on it but am not sure how to do it for this query:

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

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

Is `polyphonic` a constant or a `#variable#`? There is really [no benefit to using cfqueryparam with constants](http://stackoverflow.com/questions/17574276/how-can-cfqueryparam-affect-performance-for-constants-and-null-values/17582859#17582859). — Leigh, Sep 30 '13 at 12:13

score 0 · Answer 1 · answered Sep 29 '13 at 23:00

0

Try something like this

<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>

answered Sep 29 '13 at 23:00

James A Mohler

11,060
15
46
72

How to use cfqueryparam and NOT NULL

1 Answers1