Classic ASP Discussion - Multiple update logic problem

Print Page | Close Window

Multiple update logic problem

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=7786
Printed Date: 01 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Multiple update logic problem

Posted By: ngaisteve1
Subject: Multiple update logic problem
Date Posted: 02 December 2003 at 12:50am

I have a little question here. It is about multiple update.

For the first time, I multiple insert some records to a table and the next time, if I want to make changes (let's say insert more records), I will have redundant records isn't? So, how do I solve this problem. Insert first, then delete the redundant records. Is it possible to only insert records which is not redundant?

Eg, (I use checkbox style in a form to add records. The process page I use insert into [table] (field)values() style)
HobbiesID, Hobbies, UserID, Status
1, basketball, ,steve, yes
2, bowling, steve, yes

The next time, I come back again, the form will have both basketball and bowling's checkbox checked. If, I add select another checkbox for badminton, how the process page code look like?

Hope everyone understand my scenario here. Thanks for all feedback.