AND A.STATE IN (<cfqueryparam cfsqltype="cf_sql_char" value="#listQualify(STATE,"'")#" list="yes">)
Check to see what happens when the list is empty though. Adrian -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 16:47 To: CF-Talk Subject: ListQualify and queries 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:235875 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
