I think you're just tired....overcomplicating it. Note that all I'm doing is setting the value of the checkbox to 1. You've already got CFPARAMs to default the values to 0, and you don't need to move those form values to the session scope that I can see. Try this:
FORM PAGE: <form action="SearchSaleList.cfm" method="get"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="20"><input name="SALEITEM1" type="checkbox" value=1></td> <td>Books</td> <td width="20"><input name="SALEITEM2" type="checkbox" value=1></td> <td>Music Items</td> </tr> </table> <input type ="submit" value="submit"> </form> ACTION PAGE: <CFPARAM NAME="form.SALEITEM1" DEFAULT=0> <CFPARAM NAME="form.SALEITEM2" DEFAULT=0> <cfquery name="getsales" datasource="#dsnname#"> SELECT sm.sid as rf1,sm.SALEADDR as rf2, sm.SALEcity as rf4,sM.saletype as rf3, s.saledate as rf5, s.saletimefrom+' - '+saletimeto as rf6 FROM sale_master sm, sale s WHERE sm.sid = s.sid AND s.saleDisplay = 'Yes' AND sm.SALEreleased = 1 <cfif form.saleitem1> AND sm.saleitem1 = true </cfif> <cfif form.saleitem2> AND sm.SALEITEM2 = true </cfif> </cfquery> HTH, ~Dina ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
