I have is a set of HTML checkboxes and a Access database at the back end, when I retrieve the values of the checkboxes to process with Classic ASP I am running into a problem with undefined values.
What I have discovered from research is that if a checkbox is not checked it will not passing anything as HTML checkboxes are either selected as 'on' or 'nothing'.
However if it is checked then there is an on values passed and the yes/no field in the DB is checked.
As you can imagine the DB needs a value and if an 'undefined' value is passed to a yes/no field, it results in a missing parameter error being sent.
The compiled sql statement from a Response.Write command is:
INSERT INTO tblHome (memberID, towncity, towndistance, towndirection, propertytype, flatfloor, flatblock, nobedrooms, nobathrooms, maxnoofpeople, carneeded, carexchange, smoking, swimpool, petcare, childrenallowed, plantcare, additionalinfo, picture)values ('2', 'London', '15', 'SE', 'Flat', '3', 'CC', '2', '2', '4', undefined, on, on, on, on, on, on, 'Hello', '');
*note the undefined
Is there any way to make the 'nothing/undefined' value that is sent from the unchecked checkbox into a 'off' value so that the asp doesn’t fail?
Hope that makes sense, any help would be greatly appreciated.