I'm working on a demonstration project using ASP written with
JavaScript and an Access database. This part of the project requires
subscribers to develop a profile. Most of the information is via a
textbox, and I'm not having any problem processing it and storing it
in the database, but I'm stuck at checkboxes.

One book suggests defining the checkboxes with the same name,
different values. I've done that:

<input type="checkbox" name="chkIntersts" id="chkIntersts"
value="events"
/>Upcoming Events<br />
<input type="checkbox" name="chkIntersts" id="chkIntersts"
value="classes"
/>New Classes<br />
<input type="checkbox" name="chkIntersts" id="chkIntersts"
value="internships" />Internships<br />

I can print the areas of interest checked to a confirmation form:

<p>Interests are <%= Request.Form("chkIntersts") %></p>

What I can't do -- and I've search for hours on the internet -- is
update the database for these checkboxes.

I have set the default value for the checkboxes to NO, since only the values
of checked boxes will be passed to the server. I know (I think) that I can
inspect the form's checkbox property and extract the values, but then I need
some way to convert those values into the field names of the database.

So, my problem is that I don't know how to access the values, and then work
with them in any kind of meaningful way. I know how to build a basic INSERT
query (as I said, the text boxes have worked out fine) but I'm clueless about
building the SQL query for the checkboxes. How do I get the appropriate field
name into the query, so that I can read the box's value into the VALUE part
of the query? (I only barely know what I'm talkig about, so its possible
that this paragraph doesn't make sense!) How do I get the value translated
into Y/N?

Eventually, I'm also going to have to know how to read a record from
the database into a form ... If someone want to edit their profile,
I'd like for the form to come up with it's current settings ... but I
can wait for this!

I'd appreciate any guidance!

Thanks, Cindy