Results 1 to 4 of 4

Thread: Processing dynamic checkboxes

  1. #1
    Join Date
    Aug 2006
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Processing dynamic checkboxes

    I am working in ASP and Access database.

    I have a page with a form, inside the form there is a SELECT statement that pulls all relevent 'yes/no' columns from all relevent tables in the db and makes them checkboxes inside the form.

    Now when i check or uncheck these boxes and submit them i need to have the db updated with all the relevent changes in all the various tables.

    How can this be done? maybe there is a "FOR EACH CHECKBOX.." statement that can be used?

    Any help would be appreciated.

    Thanks, Mak.

  2. #2
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,164
    Thanks
    265
    Thanked 690 Times in 678 Posts

    Default

    db updated with all the relevent changes in all the various tables.
    I'm not sure what you mean.
    Either:

    1. You want only elements selected by a checkbox next to them to be added--
    Use if statements. if checkbox=checked...

    2. You want to add the values of a series of checkboxes. Just add them all in... no reason not to update the "irrelevant" ones too, since that's not changing anything. You could put some ifs in, but that might be complex.
    Daniel - Freelance Web Design | <?php?> | <html>| español | Deutsch | italiano | português | català | un peu de français | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

  3. #3
    Join Date
    Aug 2006
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    heres something that might make things more clear:




    Basically i want to update multiple columns in one row in multiple tables using checkboxes. The values will only be True or False.

    Thanks.

  4. #4
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,164
    Thanks
    265
    Thanked 690 Times in 678 Posts

    Default

    Ok, I think I understand now.
    However, I use php, not asp.
    This sounds pretty easy, though I can't tell you exactly how to do it.
    At first, I thought it was more complex, so I was trying to help with strategies, not exact code.
    Daniel - Freelance Web Design | <?php?> | <html>| español | Deutsch | italiano | português | català | un peu de français | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •