2. ASPRunnerPro General questions
  3. checkbox issue in V4.1 build 155
This topic is locked

checkbox issue in V4.1 build 155

 		11/15/2006 5:01:40 PM
ASPRunnerPro General questions
C
 cnewman author

I used the V4.0 to validate ASPRunner and checkboxes worked fine there but they seem to be working in a differnet way with V4.1.

In the edit page where I have checkboxes they will always show as ticked meaning that they have to be unticked each time to reflect what you want in the database. They do not seem to reflect what is currently in the database either.

I am using an MSAccess db. The field value is boolean and I have tried Yes/No and True/False.

I have browsed the forum and tried the fix adding dict("BoxApproved")="off" into the before edit event which has not worked.
P
 		Philip 11/15/2006

Hi,
had the same problem. Solution: db has to hold value 1 for yes and 0 for no.
Regards,

Philip
Sergey Kornilov admin 11/15/2006

To be exact MS Access stores Yes/No fields in -1/0 fashion.
Any nonzero numeric value will be treated as Yes, zero values are treated as No.
C
 		cnewman author 11/16/2006

Bit thick:

With that said how should I resolve it?
Turns out I may not be that thick after all:
Changed the field in db to number with default value of 0 and this all now works. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=12904&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />