do have use cfqueryparam static values?
say have clause:
where status = 1
is there benefit when doing like:
where id = <cfqueryparam value="1" maxlength="32" cfsqltype="cf_sql_integer">
i use 1 value repeatedly throughout queries.
you not need to. there no security gain param'ing static text.
however there performance gain in query optimization still gain applies when new query must run, not gain beyond first run of static query.
always param variables though.