1) Define what you mean by "extra" rows. Duplicates? 2) What kind of data is stored in the months column? Integers? String/Delimited list?
If months is a int column and you want all records with values matching one of the items in your "/" delimited list, then the code I posted previously should do just that. WHERE contractinfo.months in (<cfqueryparam value="#form.Monthselect#" cfsqltype="CF_SQL_VARCHAR" separator="/" list="Yes">) -- un-tested -- If the value of form.Monthselect was "1/3/5" then the resultant SQL would be WHERE contractinfo.months in (1,3,5) Which should return rows which the months column contained a "1" or a "3" or a "5". ~Brad -----Original Message----- From: Scott Kuo [mailto:[EMAIL PROTECTED] Sent: Friday, December 21, 2007 4:33 PM To: CF-Talk Subject: Re: Some troubles with my Query Hmm what do you think would be a good solution to filtering out extra rows. It basically to find rows with numbers like 2 or 3 or 5 in the months column. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
