This topic is locked

Check Box

10/24/2006 6:28:02 PM
PHPRunner General questions
C
Chris Patterson author

I have some ENUM fields in my database with values set as 'yes','no'

I have set the fields in the form as check boxes and it all looks good.....
But......
if I add a new record I can tick the checkboxes but on viewing the record they all appear un ticked ??

if I then remove the checkbox and leave it as a field it has the word 'no' in it !!

But if I browse the MySQL database the feild has been set to 'yes'
Am I missing something ??
I hope you can unsterstand this, not sure if I have explained it very well.
Sorry this should have been posted in phprunner

admin 10/25/2006

Chris,
PHPRunner do not support enum fields the way you trying to do this. You have two options here:

  1. Use enum field and radio button control with 'yes' - 'no' values.
  2. Use numeric field and checkbox control. Checkbox control puts 0 or 1 into database field.