<cfloop from="1" to="#listLen(variables.fieldlist)#" index="variables.index">
    <cfif listGetAt(variables.fieldlist, variables.index,',') eq "ProductNo">
        <cfset MyQueryString = '[ProductNo] = ' & #form.sSearch# & ' '>
     </cfif>
     <cfif listGetAt(variables.fieldlist, variables.index,',') eq "ProductName">
        <cfset MyQueryString2 = '[ProductName] Like ' & chr(34) &#form.sSearch# & chr(39) &' '>
     </cfif>

    <!--- <cfif variables.index LT listLen(variables.fieldlist)> <cfset MyQueryString = MyQueryString & " OR "> </cfif>--->

     <cfset MyCompleteString = MyCompleteString & PreserveSingleQuotes(MyQueryString)>
</cfloop>