cfquery param on query containing if statment

Question

How do you use cfqueryparam on this line of code?

SET mailing_list = <CFIF IsDefined("FORM.mailing_list")>#FORM.mailing_list#<CFELSE>0</CFIF>

Answer 1

you would just use two separate cfqueryparam's

SET mailing_list = 
<cfif StructKeyExists(form,'mailing_lis't)>
  <cfqueryparam cfsqltype="cf_sql_varchar" value "#FORM.mailing_list#" />
<cfelse>
  0
</cfif>