Re: Checkbox woes
I think you're just tiredovercomplicating 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: Books Music Items ACTION PAGE: 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 AND sm.saleitem1 = true AND sm.SALEITEM2 = true 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
Checkbox woes
I figured out the issue after some sleep. I was using a method of get for the form and the vars in my action page were looking for form. not url. Sleep does has it's puurpose! ~| 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
Re: Checkbox woes
You're using session variables in the query, but you're not setting them anywhere on this page. - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2003 11:25 PM Subject: Checkbox woes > I am have a bit of a time with this whole checkbox thing. The check boxes are for users to select an item if they want to include it in the search. They always return a 0 instead of a 1 if I have a box checked thus it is not being used by my query on the action page as a search criteria. > > Maybe I am tired but I need to get this done. The follwoing is my form code followed by the action code. Any help is appreciated in advance. > > FORM PAGE: > > > > > Books > > Music > Items > > > > > > ACTION PAGE: > > > > > > > > > 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 > AND sm.SALEITEM1 = #session.vSI1#) > AND sm.SALEITEM2 = #session.vSI2#) > > > > Get your own free email account from > http://www.popmail.com > > ~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checkbox woes
Not sure exactly what you're trying to do but two things I'll mention: 1. Always remember that if a check box IS NOT checked the field is never passed in the form. You'll need to use CFPARAM or something to set the default to 0 just in case the box is not checked. 2. Why are you setting the value of your checkbox to "on"? Why not just set it to "1" instead? -Novak - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2003 10:25 PM Subject: Checkbox woes > I am have a bit of a time with this whole checkbox thing. The check boxes are for users to select an item if they want to include it in the search. They always return a 0 instead of a 1 if I have a box checked thus it is not being used by my query on the action page as a search criteria. > > Maybe I am tired but I need to get this done. The follwoing is my form code followed by the action code. Any help is appreciated in advance. > > FORM PAGE: > > > > > Books > > Music > Items > > > > > > ACTION PAGE: > > > > > > > > > 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 > AND sm.SALEITEM1 = #session.vSI1#) > AND sm.SALEITEM2 = #session.vSI2#) > > > > Get your own free email account from > http://www.popmail.com > > ~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Checkbox woes
I am have a bit of a time with this whole checkbox thing. The check boxes are for users to select an item if they want to include it in the search. They always return a 0 instead of a 1 if I have a box checked thus it is not being used by my query on the action page as a search criteria. Maybe I am tired but I need to get this done. The follwoing is my form code followed by the action code. Any help is appreciated in advance. FORM PAGE: Books Music Items ACTION PAGE: 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 AND sm.SALEITEM1 = #session.vSI1#) AND sm.SALEITEM2 = #session.vSI2#) Get your own free email account from http://www.popmail.com ~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
