pass comma separated values in CFQuery / listqualify single quoted values

select distinct ruleid from MyRulesWITH (NOLOCK)
where
fieldid in (<cfqueryparam value="#arguments.fields#" cfsqltype="cf_sql_varchar" list="true" />)

<cfif variables.scorecardIds neq "">
  and name in (#listqualify(variables.name,"'",",")#)
</cfif>