SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Jun 17, 2003, 15:34 #1
- Join Date
- Mar 2003
- Location
- Melbourne, Australia
- Posts
- 463
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
how to get the value of a checkbox into an access db
hi guys
i have a form that i made
that has a checkbox on it
i want the value of the checkbox (on or off)
to go into an access database
the database field is a yes/no field
and i tried it with changing the value to be
a boolean variable but i got a data or type mismatch
does anyone know how to update a yes/no field?
my code is approx:
INSERT INTO [table] ([checkboxVal]) VALUES ([Request.form("checkbox")])
dim blnChk
blnChk = true
INSERT INTO [table] ([checkboxVal]) VALUES (blnChk)
where the asp code is outside the " ", so you don't need
to point that out
thanks
-
Jun 17, 2003, 21:47 #2
- Join Date
- Mar 2003
- Location
- Melbourne, Australia
- Posts
- 463
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
already got an answer
Bookmarks