Discussion Locked
0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are developing an application using ASP, Personal Web server on Win98SE, and SQL Server 7. We noticed that when using an IE5.5 browser, the module that creates a record is executed twice despite our conditional statements and re-direction. At themoment, we are trying to check if 2 records have been inserted and then deletes the second one. This doesn't happen with IE5.0 browsers. Our IE5.5 is with Service Pack 2. I really don't know what to make of this. Help.
4 replies
by mark.thomson
There are a couple of things you can do on the SQL server side.
1 Use an index to prevent duplicate records from being inserted
or
2 If you are using a stored procedure to manage your insertions then you can check for pre - existing records
eg check woudl look something like this
IF (Select Count(*) From table where ..) = 0
BEGIN
INSERT ...
END
HTH
by jomard
Poster rated this answer
by jomard
A co-worker who encountered a similar problem said that the latest MSDN is suggesting to use the FireEvent instead of the submit method. It seems that IE5.5 is not supporting the submit method. Is this true?
by jomard
This question was closed by the author
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
0 helpful
1 reply
0 helpful
1 reply
0 helpful
1 reply
1 helpful
3 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply