Asp updating access check box

However, nothing gets updated now (where the other 4 fields were OK earlier).

Form("frm Register") & "', '" I get the error message that there is a string error. abf = "INSERT INTO [registration] ( register, newusername, email, newpassword ) VALUES " & "('" & Request.But then I get the error message that there is a criteria mismatch.If I change the insert line from: abf = abf & Server.In the mean time, I have recreated the Yes/No field to be a Text Field which stores "Yes" or "No", and the checkboxes update correctly in both display mode and when I go into Edit mode. Using the Ole Db Command, if I do not consider the Yes/No field, the Execute Non Query command, using my UPDATE SQL statement, updates the record correctly.However, nothing gets updated now (where the other 4 fields were OK earlier). However, if I put the Yes/No field into the mix, Execute Non Query returns 0 (0 records updated).

Search for asp updating access check box:

asp updating access check box-43asp updating access check box-11asp updating access check box-34

Using the Ole Db Command, if I do not consider the Yes/No field, the Execute Non Query command, using my UPDATE SQL statement, updates the record correctly.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “asp updating access check box”