Getting Checkbox to populate checked fields

ok...so i have 2 check boxes labeled Y and N. When the user initially fills then in it sends either a Y or N to the tLetter column in my database....

I have been looking for code and found this and can not get it to work




any ideas why this isnt working....??? when i go into my DB the field definately is labeled with a Y....

what are you trying to do again, trying to have the appropriate checkbox initially checked?

Like someone fills out one form, then someone goes back into open the form from a link and I want the form input checkbox for Yes to have a check if there is a Y in the database from the previous user that filled out the initial form. Make sense?

but basically yes, i want them to have the correct checkboxes checked if someone wants to reopen the form.

Can you not just do <cfif letter>selected</cfif>?

Also are you sure the database isn't putting in a Y by default?

I know it isnt putting the Y in by default b/cause it passes a null value if nothing is put in, Y if they select the Y box and N if they select the N box.

Basically I need to learn how to have checkboxes checked on forms from an initial form...here is the flow of this form...

1. user fills out form, checks boxes where appropriate....

2. user goes to page that shows linked names of forms they filled out and click link

3. link opens an update page...now I need the same checkboxes to be checked as where on the first page....

if you are trying to pass form between pages, just use session to save it... but in your case, fetching from database, kiteless is right, you can use cfif statement within the input tag...




no? i think it should work..

I know it isnt putting the Y in by default b/cause it passes a null value if nothing is put in, Y if they select the Y box and N if they select the N box.

Basically I need to learn how to have checkboxes checked on forms from an initial form...here is the flow of this form...

1. user fills out form, checks boxes where appropriate....

2. user goes to page that shows linked names of forms they filled out and click link

3. link opens an update page...now I need the same checkboxes to be checked as where on the first page....

well i put this in

checked="<cfif letter eq "Y">yes<cfelse>no</cfif>"

and now everytime i reload the page whether the Y is a Y in the database or not it selects the Y checkbox...

k, this should work -->



i guess cfinput doesnt accept checked="no" ... so just return nothing after cfelse... it worked for me.

nah bro now it just doesnt show anything....I don tsee why it is so hard to just do this....I have looked all over the web for this stuff too and cant find it

With all this discussion I'm still not clear what you are trying to do. Is it this: if the database has the value 'Y' for one field, then when you display that record you want a checkbox checked for that value?

If that is correct, then this is all you need to do:

<cfset myFlag = 'Y' />

<input type="checkbox" value="Y" <cfif myFlag eq 'Y'>checked</cfif>>

kiteless doesnt that always set the value to Y? It leaves the checkbox always checked. There is also a N check box and they are both named tLetter. If the first user who filled out the form clicks on the N text box then the DB will populate with a N. so either if it is Y or no and someone else goes to look at the form at a later date. i want the checkbox to have the appropriate one checked. All of the options given to me thus far have either left it checked no matter what or done nothing. I have in my db like 5 examples 2 w/ y's in the tLetter field and 3 w/ N's. And when I run all of these examples it doesn't show up correctly.....u get what I am saying now?

Well first, if you want this to always either be yes or no, you should use a radio button not a check box.

But aside from that, no I don't see what you are saying. If your database field has an N in it for the field myQuery.booleanField, then this code would have the NO box checked:

<input type="checkbox" value="Y" <cfif myQuery.booleanField eq 'Y'>checked</cfif>> Yes
<br>
<input type="checkbox" value="N" <cfif myQuery.booleanField eq 'N'>checked</cfif>> No

Well the thing is is they are optional Yes or No's....Neither has to be selected for the form to go through. I dont know why but none of these code lines that have been sent to me have worked. I understand exactly why it should work like this but see no reason why not. Is there any way I have to possibly have my db column for tLetter be a type of for this to work?