SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Evangelist
    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

  2. #2
    SitePoint Evangelist
    Join Date
    Mar 2003
    Location
    Melbourne, Australia
    Posts
    463
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    already got an answer


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •