Updating multiple records using checkboxes not working

Hi,

I'm trying to get my page to update multiple records using the DataAssist multiple update behaviour. I'm not getting any page errors, but the records are not being updated.

I've noticed too that in the multiple record update wizard when I get to the stage where I bind form values to the database field I want to update there is no option to choose my checkbox field and if I enter a literal value and finish the wizard, then re-enter the wizard upon visiting the bindings screen again my literal value is not remembered.

I've attached a copy of my page.

your checkbox does not have a checked value. Change:

<input <?php if (!(strcmp($row_rsGetUnapprovedFreelancers['Authorised'],1))) {echo "checked=\"checked\"";} ?> type="checkbox" name="Approved_<?php echo $RepeatSelectionCounter_1; ?>" id="Approved_<?php echo $RepeatSelectionCounter_1; ?>" />

to:

<input name="Approved_<?php echo $RepeatSelectionCounter_1; ?>" type="checkbox" id="Approved_<?php echo $RepeatSelectionCounter_1; ?>" value="1" <?php if (!(strcmp($row_rsGetUnapprovedFreelancers['Authorised'],1))) {echo "checked=\"checked\"";} ?> />

also change:

$WA_fieldValuesStr = "1";

to:

$WA_fieldValuesStr = "".WA_AB_getLoopedFieldValue("Approved", $WA_multipleUpdateCounter)  ."";

Thank you Jason, it's working now.

you're welcome.