M
middletree
I'm used to SQL Server, but for a project working at home, have to use
Access. On the ASP form, I have some text fields and some checkboxes, and
the text fields work fine. The checkboxes give me errors, though. I'm doing
this from memory, but I beleive the data said I was putting the wrong type
of data into the field.
The HTML for the checkbox is
<input type="checkbox" name="whatever" value="yes">
In Access' design view, the field is clearly a YES/NO field.
When I do a response.write, I get something like
INSERT INTO Tablename (FName,LName,Whatever) VALUES ("Joe","Dirt","yes"),
where the first two fields are text fields and the last one is the field
which is giving me problems.
Do I have to change this to "ON/OFF"? Any other reason I could be having
this trouble?
Access. On the ASP form, I have some text fields and some checkboxes, and
the text fields work fine. The checkboxes give me errors, though. I'm doing
this from memory, but I beleive the data said I was putting the wrong type
of data into the field.
The HTML for the checkbox is
<input type="checkbox" name="whatever" value="yes">
In Access' design view, the field is clearly a YES/NO field.
When I do a response.write, I get something like
INSERT INTO Tablename (FName,LName,Whatever) VALUES ("Joe","Dirt","yes"),
where the first two fields are text fields and the last one is the field
which is giving me problems.
Do I have to change this to "ON/OFF"? Any other reason I could be having
this trouble?