Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Retaining values in check boxes

New Here ,
Jul 07, 2006 Jul 07, 2006
I have a form and one field is a check box. When someone checks the box it submits it to the database as YES and if it remains unchecked it means NO. My problem is if someone has made a check in the box, and then later uses the update form, the box is unchecked. I used the bindings tab to make sure the database queried the box just like a normal text field but it doesn't seem to keep the box checked when it calls the record up. Any ideas?

Using PHP/MySQL/DW8
TOPICS
Server side applications
224
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jul 07, 2006 Jul 07, 2006
LATEST
Eiolon wrote:
> I have a form and one field is a check box. When someone checks the box it
> submits it to the database as YES and if it remains unchecked it means NO. My
> problem is if someone has made a check in the box, and then later uses the
> update form, the box is unchecked.

Select the checkbox, and then click the Dynamic button in the Property
inspector. In the Dynamic Checkbox dialog box, click the lightning bolt
icon to the right of Check if, and select the correct field from your
recordset. Enter the value you want it to equal in the Equal to field.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines