I've actually approached this in a different way than I have enquired about, but it would be useful to know if one can show or hide a specific field still.
Anyway, I now have an issue with the way I have approached it. I've decided to make a new table with the text in a single record using multiple fields so that the info is updated easily using an update and detail page created by DataAssist.
My new issue is that I have got a newsletter sign up page which shows or hides particular regions. These regions are three checkboxes which can be hidden or shown independently. If a checkbox is hidden, then it submits a value of 1 regardless of the fact I've replaced it with a hidden field with a value of 0.
So to clarify, if I am hiding one of the checkboxes then I am ensuring that I am presenting the insert script with an alternative hidden field with the same name and ID but it has a value of 0, but it's entering into the DB as a 1. I can't figure out why. I've done this kind of if/else procedure so many times successfully, but I just can't figure out what's going wrong this time.
What's happening is:
- boxes visible and checked enter 1 in the DB -- this is OK
- boxes visible and UNchecked enter 0 in the DB -- this is OK
- boxes replaced with a hidden field with a value of 0 enter 1 -- this is wrong
I've attached the code.