Try something like:
<cfset flds = "">
<cfloop from="1" to="#fieldnumber#" index="x">
<cfset flds = listappend(flds,"isdefined('field_#x#')","|")>
</cfloop>
<cfset flds = replace(flds,"|", " AND ","ALL")>...