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.

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

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.

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

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

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

...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

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?

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:

and here is the form code