Checkbox/Database/Flash Form

[amy_jo]

I have an access DB with several yes/no fields that I want to appear as
checkboxes in a flash form.

When I try to query the db, the checkboxes don't show the value - when changed
to a text field I can see that value is 1(for yes).

How do I get the checkbox to recognize the yes/no from the db and mark it as
checked if it exists?

[Dan Bracuk]

What do you mean the checkboxes don't show the value? What method did you use to check, and what did you see?

[amy_jo]

Ok, here is what I have - it is pulling the text data(test type):

<cfformgroup type="page" label="Vision Screening">
<cfoutput query="Vision">
<cfinput type="datefield" name="vTestDate" label="Date Tested"
bind="#Vision.Date#">
<cfinput type="text" name="VTestType" label="Test Type"
bind="#Vision.TestType#">
<cfinput type="checkbox" name="VisionPerm" label="Permission to Test"
bind="#Vision.Permission#" value="#Vision.Permission#">
</cfoutput>
</cfformgroup>

Thanks for the fast response and not laughing me out of here :D

[amy_jo]

hi everyone - still needing a solution for this - what am i doing wrong?

[TSB]

When you say "doesn't show the value" do you mean it is not checked if it is 1
in the database?

I don't see where you have the checked option. If you want it to be chacked
you need to have the word checked in the tag. You can do it this way.
<cfif vision.permission>
<cfset checkedFlag = 'checked'>
<cfelse>
<cfset checkedFlag = ''>
</cfif>
<cfinput type="checkbox" name="VisionPerm" label="Permission to Test"
bind="#Vision.Permission#" value="#Vision.Permission#" #checkedFlag#>

I assume the permission field is 1 or 0 so the cfif statment should work as is.

Trevor
[url]http://www.burnette.us[/url]