Discussion Locked

Double SQL Insert when using IE5.5

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

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?

This discussion is closed to new replies.