Well - I don't know what the official "common" practice is for checking
checkboxes -
But if you set up the cfparam - it will always test "true" for IsDefined, so
I think the better thing is to test for the VALUE of your checkbox... after
setting up a default value for it.
<cfparam name="form.tips" default="no">
<cfif #FORM.tips# eq "NO">
Do something
<cfelseif #FORM.tips# eq "YES">
Do Something Else
<cfelse>
A mistake was made?
</cfif>
That is what I usually do anyway....
On a side note: If your FORM is asking a YES/NO question - it is probably
better to use a RADIO button rather than a check box - as a check box will
allow them to choose both Yes AND No - which is probably an undesirable
result. (You can use a checkbox if you only want the "YES" value... "Check
the box to subscribe to health tips... etc.")
Does that Help?
- Nick
-----Original Message-----
From: John Barrett [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2008 11:32 PM
To: CF-Newbie
Subject: Re: checkboxes and INSERT
Hi Paul,
Thanks so much, as that fixed the issue, but can I ask:
would you still use cfif IsDefined? when you have a cfparam?
I asked a while back on this list,and was helped by somebody, who
said that the proper way to check a checkbox should be done cfif
isDefined.
I am curious, as I want to learn, and not just get code working,
thanks so much
John
On Jun 18, 2008, at 4:14 PM, Paul Kukiel wrote:
> Hi John,
>
> Put this at the top of the results_page.cfm presuming no option
> checked
> means no.
>
> <cfparam name="form.tips" default="no" />
> <cfparam name="form.health" default="no" />
>
> Paul.
>
> -----Original Message-----
> From: John Barrett [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 19 June 2008 12:00 PM
> To: CF-Newbie
> Subject: checkboxes and INSERT
>
> I am having an issue with writing a checkbox to my database. The
> code works
> fine with POST, but when I try to add it to a cfquery, I get an
> issue(I
> think) with "cfif IsDefined". I wanted a situation that if the
> checkbox was
> not checked to have an error message. All works fine when I comment
> out the
> cfquery,and just post the data, but if the checkbox is not checked,
> I get an
> error that it is not defined in form. Why would this form break by
> writing
> it to a db?
>
> Thanks so much for any help,
> John
> /----------form_page.cfm------------------/
> <cfform action="results_page.cfm" method="post">
>
> <b>Are you interested in Today's Senior tips e-mailed to you?</b><br>
> <table width="391">
> <tr>
> <td width="113"><cfinput type="checkbox" name="tips" value="yes">
> yes</td>
> <td width="134"><cfinput type="checkbox" name="tips" value="no">
> no </td>
>
> </tr>
> </table>
>
> <b>Are you interested in recieving other health information for
> seniors
> e-mailed to you?</b><table width="391">
> <tr>
> <td width="113"><cfinput type="checkbox" name="health"
> value="yes">
> yes</td>
> <td width="134"><cfinput type="checkbox" name="health" value="no">
> no </td>
> </tr>
> </table>
> <!--- submit button --->
> <cfinput type="Submit" name="SubmitForm" value="Submit">
> <!--- Reset button. --->
> <cfinput type="Reset" name="ResetForm" value="Clear">
> </cfform>
> /----------action_page.cfm------------------/
> <cfoutput>
>
> <!--- If any mail alerts were checked, output them --->
> <cfif IsDefined('form.tips')>
> <b>Tips was chosen?</b> #tips#<br>
> <cfelse>
> <b>Tips were chosen:</b> No Tips were selected<br>
> </cfif>
>
> <!--- If any mail alerts were checked, output them --->
> <cfif IsDefined('form.health')>
> <b>topics:</b> #health#<br>
> <cfelse>
> <b>health was chosen?</b> No health products were selected<br>
> </cfif>
>
> <!--- Insert checkbox data into DB--->
> <cfquery datasource="MYDSN">
> INSERT INTO tip(tips, health)
> VALUES ('#FORM.tips#', '#FORM.health#')
> </cfquery>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3768
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
