checkbox data not updating

Hi

I created a form with DataAssist, which works fine.

I then added some fields in the database table (enum field type, 'yes' or 'no', 'no' by default)

I returned to the form and added checkboxes for the additional fields, altered the update behaviour etc etc.

However, the fields are not updated if I try to change any of them.

If I make a change direct in the database, then the changes are reflected when the page opens (i.e. certain fields will be checked), so the retrieving part of the page is working properly.

In the form, the checked value = yes :

<input <?php if (!(strcmp($row_WADAlistings['MobilityIcon'],"yes"))) {echo "checked=\"checked\"";} ?> name="ckmobility" type="checkbox" id="ckmobility" value="yes" />

In the update behaviour, the update field is set to type 'text, with the value such as the following:

<?php echo ((isset($_POST["ckmobility"]))?$_POST["ckmobility"]:""); ?>

I have even tried creating a new page just with the checkboxes on, but this doesn't work either (I note it defaults to checkbox value = '1'', do I need to change the field format in the database? Not a problem as I'm still developing at the moment)

TIA
Cheers

Chris

please send a copy of your page so I can examine the code in its entirety.

Hi Jason

txt file attached. You will not I've started trying radio buttons in addition to checkboxxes - these don't work either!

Cheers

Chris

I dont see any attached file.

Please compress the php file into a zip archive and attach the zip file to your reply.

Oops! Hopefully this gets there

Thanks

Chris

try changing the no option:
<input <?php if (!(strcmp($row_WADAlistings['MobilityIcon'],"no"))) {echo "checked=\"checked\"";} ?> type="radio" name="ckmobility" id="radio2" value="no" />

value to blank:
<input <?php if (!(strcmp($row_WADAlistings['MobilityIcon'],"no"))) {echo "checked=\"checked\"";} ?> type="radio" name="ckmobility" id="radio2" value="" />




Then in the Update record server behavior, set the data type for the checkbox column to be Checkbox Yes/ No

Hi Jason

No good - didn't make any difference.

However, I have tried removing the WA Update process and applied the Dreamweaver Update process and it all works fine!

Cheers

Chris

can you send a copy of the dream weaver update page, this may help me determine why data assist was not working.

Hi Jason

File attached. You will notice I've changed them all to radio buttons!

Cheers

Chris

what was the solution to this? it may be related to what I'm trying to fix...thanks