use ms access checkboxes in a web form

<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->
<%
Option Explicit
Session.CodePage=65001
Response.Charset="UTF-8"
%>
<!--#include virtual="include/paramSQL.asp"-->
<%
' We will get the selected name from the form
' and use it to look up the value of the 
' YES/No (TRUE/FALSE) field in the database.
' If the field is "Yes" (or "True")
' we will make the form's checkbox checked.

Dim locName, checked

' get the name submitted
if request.form("name")<>"" then
    locName = LCase(Trim(request.form("name")))
else
    ' default to John
    locName = "John"
end if

' look it up in the database and return an
' empty string or "CHECKED".
checked = getCheckedByName(locName)

function getCheckedByName(pName)
  ' This function uses the paramSQL.asp library
  ' The library just simplifies database access,
  ' enforces error handling and adds some debug
  ' information for the developer. A link is
  ' provided at the end of the code.
  Dim cmdText
  getCheckedByName=""

  cmdText = "SELECT understands FROM yesnoexample WHERE ([name] = @name);"

  openCommand Application("examples"),"getCheckedByName"
  addParam "@name",adVarChar,adParamInput,CLng(50),pName,"getCheckedByName 1"
  getRS db_rs, cmdText, "getCheckedByName"
  if NOT (db_rs.BOF AND db_rs.EOF) then
    '**************************************************
    '* The important part. If "True" return "CHECKED" *
    '**************************************************
    if db_rs("understands") = "True" then
      getCheckedByName="CHECKED"
    end if
  end if 
  closeCommand
end function
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang="en">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="author" content="Roderick Divilbiss">
<meta name="copyright" content="© 2005, 2006 Roderick Divilbiss">
<title>display access checkboxes in a web form</title>
</head>

<body>
<form method="POST" action="access_checkbox.asp">
<p><input type="text" size="20" name="name" value="<%=locName%>&nbsp;Understands&nbsp;
   <input type="checkbox" name="understands" value="true" <%=checked%>><br>
   <input type="submit" value="Get the Yes/No value for this name" name="submit">
</form>
</body>
</html>

How can you retrieve a YES/NO (TRUE/FALSE) field from a MS Access database and show its value in a checkbox on a web form?

Most Popular Pages On rodsdot.com