Dynamic Checkboxes in Rich Forms

Cranners · Cranners

Hi, I am just in the process of working with rich forms in CF MX7. I am trying
to display checkboxes created from a query. The form is displayed, however, the
check box labels are all being set to the first record in the database. Please
could someone tell me how to get the correct labels to be displayed? See the
code below:

<cfquery name="GetCert" datasource="#application.dsn#">
select * from Certifications
order by CertName
</cfquery>

<html>
<head>
<title></title>

</head>
<body bgcolor="#FFFFFF" text="#000000">
<cfform action="staffcert2.cfm" method="post" format="Flash" height="400">
<cfformgroup type="repeater" query="GetCert">
<cfinput type="checkbox" name="Certified"
bind="{GetCert.CertID[GetCert.CurrentRow]}"
label="#GetCert.CertName[GetCert.CurrentRow]#">
</cfformgroup>
<cfinput type="submit" value="Select" name="Submit" />
</cfform>
</body>
</html>

nimer · nimer

2 problems you are trying to bind the value with client side markup {}
(processed on the client) and the labels with server size ## (processed by CF)
if you want to use cfloop to loop over the checkboxes, then you want the server
side version. However, if you are using the repeator cfformgroup then you are
processing the loop on hte client and need to use the client side version. try
this <cfformgroup type='repeater' query='GetCert'> <cfinput type='checkbox'
name='Certified' value='{GetCert.currentItem.CertID}'
label='{GetCert.currentItem.CertID}'> </cfformgroup> One bit of caution, the
column names are case-sensitive. So you need to make sure the CertID column, is
the same as column case in your db? or in the SQL? hth, ---nimer

Cranners · Cranners

Hi, Thanks, that worked. I tried using server side ## with CFLOOP but that
just gave me a blank form, no content. I changed my code to:

<cfloop query="GetCert">
<cfinput type="checkbox" name="Certified" value="#GetCert.CertID#"
label="#GetCert.CertID#"><br>
</cfloop>

johnnyred · johnnyred

I tried using the same code format with the repeater for checkboxes. The form displays fine, but all the checkboxes are checked when the form first displays...any ideas?

thanks...

Cranners · Cranners

From what I've read it looks like you have to use a checked='false' parameter with CFINPUT

johnnyred · johnnyred

Yes, I tried that. But the checkboxes are still pre-checked. Odd.

Mike Nimer · Mike Nimer

This is a known bug, when using the repeator.

---nimer

"johnnyred" <webforumsuser@macromedia.com> wrote in message
news:cvij6m$ad9$1@forums.macromedia.com...

> Yes, I tried that. But the checkboxes are still pre-checked. Odd.

johnnyred · johnnyred

Well, that explains that...I will move onto something else.

Thanks.

Dynamic Checkboxes in Rich Forms

Thread Tools

Display

Dynamic Checkboxes in Rich Forms

Similar Questions and Discussions

Dynamic Checkboxes

Checkboxes with the same name in Flash forms

Rich flash forms and validation functions

Multiple choice checkboxes in PDF forms

Dynamic checkboxes and INSERT into DB

Re: Dynamic Checkboxes in Rich Forms

Re: Dynamic Checkboxes in Rich Forms

Re: Dynamic Checkboxes in Rich Forms

Re: Dynamic Checkboxes in Rich Forms

Re: Dynamic Checkboxes in Rich Forms

Re: Dynamic Checkboxes in Rich Forms

Re: Dynamic Checkboxes in Rich Forms

Posting Permissions