I have a gridview control getting boolean data from a database. These fields are show as checkboxes. My problem is that the @FieldName
in the update does not seem to be returning a boolean value.
My update statement has multiple boolean fields and is longer that the example below:
UPDATE employees SET isAdmin = @isAdmin, hasPicture = @hasPicture,... WHERE empolyeeID = @employeeID
This update works if I use this
UPDATE employees SET isAdmin = true, hasPicture = false,... WHERE empolyeeID = @employeeID
I have tried cBool(@isAdmin) but this always returns true even if the check box is not checked. I even tried the old SQL CONVERT ut that did not work.