Given the following code inside a <cfquery> ...
<cfif listLen(STATE) eq 1>
WHERE A.STATE =
<cfqueryparam cfsqltype="cf_sql_char" value="#STATE#">
<cfelseif listLen(STATE) gt 1>
AND A.STATE IN (#listQualify(STATE,"'")#)
</cfif>
is there an easy way to use CFQUERYPARAM in this scenario when there are
more than one STATE option?
rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235873
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
