Checkboxes undefined when not checked MS Access

Morn · February 15th, 2007, 04:53 PM

I have a page that enters the values of multiple fields into an access DB. It all works (even the checkboxes) until I donât tick a checkbox.

The value undefined get passed to eh DB and I can not find a way around it anywhere.

I am using JavaScript and the code I am using for the boxes and insert statement is below.

Code:

 sql = "INSERT INTO tblHome (memberID, towncity, towndistance, towndirection, propertytype, flatfloor, flatblock, nobedrooms, nobathrooms, maxnoofpeople, carneeded, carexchange, smoking, swimpool, petcare, childrenallowed, plantcare, picture)"
    sql = sql + "values ('" + varuserID + "', '" + vartowncity + "', '" + vartowndistance + "', '" + vartowndirection + "', '" + varhometype + "', '" + varflatfloorno + "', '" + varflatblock + "', '" + varnobed + "', '" + varnobath + "', '" + varmaxpeople + "', " + varcarneeded + ", " + varcarexchange + ", " + varsmoking + ", " + varswim + ", " + varpet + ", " + varchildallow + ", "+ varplantcare + ", '" + varpic + "');";

Code:

<input type ="checkbox" name ="carYESNO" value = "on"/>

dparsons · February 15th, 2007, 05:00 PM

Its been a long while since I have used access but, if memory serves me, checkboxes are just Bit values (Valued as 0 and 1) a check would be 1 anything else would be 0 so if the checkbox is not ticked in your application set your variable to 0 and pass that into your insert and see if you have better luck. hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Morn · February 15th, 2007, 05:05 PM

Thanks for your reply; logically thatâs exactly what I got. However Access seems to have its own ideas and takes the value of a non ticked checkbox and says its undefined.

This is the message I get if I uncheck just one box:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

dparsons · February 15th, 2007, 05:10 PM

try passing in NULL as the parameter then.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Morn · February 15th, 2007, 05:12 PM

Sorry to say that this shows my basic level of understanding, how would i do that?

dparsons · February 15th, 2007, 05:16 PM

Something like:

INSERT INTO <table>(column)Values(NULL)

Also, don't enclose NULL with ' ' (which would make it a string literal) just pass it in as NULL but, before you do this, make sure you have allowed NULL to be inserted into that column.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

grstad · February 15th, 2007, 06:01 PM

...I'll just give you these hints;

1. Read the appendix F in the book ASP 3.0

2. If you are prevented from that, it says;

"Independent check boxes:
      Each NAME is different
      Do not use VALUE
      Test for NAME ="on"

Grouped check boxes:
      All NAMES are the same
     Each box gets its own VALUE

Sample 1, single checkbox:
      <form action = "a" method = get>
      <input type = Checkbox name = "Swahili"> Some text
      <input type = submit>
      </form>

      a:
      If request.querystring("Swahili")="on" then
       ....
      end if

Sample 2, multiple independent checkboxes
      <form action = "a" method = get>
      <input type = Checkbox name = "Swahili"> Some text
      <input type = Checkbox name = "Swa" checked> Some text

      <input type = submit>
      </form>

      a:
      If request.querystring("Swahili")="on" then
       ....
      end if

     If request.querystring("Swa")="on" then
       ....
      end if

Sample 3, groups of checkboxes
      <form action = "a" method = get>
      <input type = Checkbox name = "Swahili" value = "Swahili">Some text
      <input type = Checkbox name = "Swa" value = "Swa" checked> Some text
      <input type = Checkbox name = "Swahi" value = "Swahi"> Some text
      <input type = Checkbox name = "Swai" value = "Swai"> Some text

      <input type = submit>
      </form>

      a:
      If request.querystring("Swahili")="on" then
       ....
      end if

     If request.querystring("Swa")="on" then
       ....
      end if

      If request.querystring("Swahi")="on" then
       ....
      end if

     If request.querystring("Swai")="on" then
       ....
      end if"

And if you are still confused, ask again! Do you need to have VALUE = "ON" in your code?

Mvh
grstad

Morn · February 15th, 2007, 06:35 PM

Ok I think I get where your going with this, to my general (limited) understanding I do not need the value set
as 'on' as this is the default. As you say I need to query the value passed before it is sent to the db, what
I am ashamed to say is that i didnât get the examples you gave. Sorry any further help?

solos · February 15th, 2007, 07:01 PM

I use the following bit of code to pass values from a checkbox to a database true/false field. Maybe you can apply the concept to your situation:

Code:

        strSupport = Request.Form("support")

            if strSupport = "checked" then
                strSupport = "-1"
                 end if
              if strSupport = "" then
                  strSupport = "0"
                 end if

solos · February 15th, 2007, 07:04 PM

and here is the form code

Code:

cust_support = rs("Cust_Support")
Support = <input type="checkbox" name="support" id="support" value="checked"
<%
if cust_support = "True" then
%>
checked="checked"
<% end if %>
/>