The easiest way to accomplish this is to delete whatever exists in the database for that user and then do new inserts for the ones that they select. So, using your example below where the user has 1 & 2 checked, then selects only #3, I would delete all entries for this user (1 & 2) and insert #3. Mark
mcwilliams132 <[EMAIL PROTECTED]> wrote: Greetings! I've been banging my head against a wall for the last couple days trying to figure out how I can dynamically update a few checkbox values stored within a SQL table I'm using for a scope for a web site I'm building. Here's what I want to accomplish: I have a form that allows a user to enter some text and then via checkboxes, choose where on a web site this text appears (typically only 3 pages - so 3 checkboxes). The checkboxes are assigned a value of 1, 2 or 3 to correspond to the page they appear on. Adding their values to the table and bringing them back to a form for editing is no problem (showing which one's are checked)...it's submitting the changes that's causing me the headache. THE QUESTION: So if you originally chose option 1 & 2, submitted, but then change your mind and now just want option 3...How do I check which item to delete, add or leave alone? Thanks for any assistance you can give me... Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
