hidden field not populating column
i am using DA with a repeat selection from a recordset and the hidden field that DA creates: <input type="hidden" name="took_attendance_mihidden_<?php echo $RepeatSelectionCounter_2; ?>" id="took_attendance_mihidden_<?php echo $RepeatSelectionCounter_2; ?>" value="A" /> ---> it's value "P" is not being passed into the database column if the checkbox that it represents is not "checked".
the default value that DA associated with the hidden form was "1" and I changed it to "A" as it is an attendance form and who is present should be recorded as "P" and who is absent should be "A"
any help would be much appreciated
After looking into the database further I've discovered a greater problem..
The inserted rows is the first returned rowset from the query, repeated over and over.
I thought the query was at fault but ran it through Devart's Query Builder and it returned correct results...
I hope this is something that has been seen before
I've included an updated version of the file, attendance_2.zip is latest