method="POST" causing multiple database inserts

[sdidomenico]

Hello,

We have a new ASP/SQL Server application that has been running for (6) months. On at least (4) occasions a POST has been sent from the Browser yet it runs multiple times on the Server. This causes the same record to be inserted multiple times into the database. There is no pattern to this. In addition, the User cannot click "save" more than once as the application will redirect them to a view page.

Here are the entries from the IIS Log on this matter, for security reasons the IP Address has been changed to 9.9.9.9 and 9.9.9.8:

2004-03-11 14:21:03 9.9.9.9 - 9.9.9.8 8080 POST /donor/manage_donor.asp - 302 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)

2004-03-11 14:21:03 9.9.9.9 - 9.9.9.8 8080 GET /donor/view_donor.asp iDonorId=100256509 200 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)

2004-03-11 14:21:03 9.9.9.9 - 9.9.9.8 8080 POST /donor/manage_donor.asp - 302 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)

2004-03-11 14:21:03 9.9.9.9 - 9.9.9.8 8080 POST /donor/manage_donor.asp - 302 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)

2004-03-11 14:21:03 9.9.9.9 - 9.9.9.8 8080 POST /donor/manage_donor.asp - 302 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)

2004-03-11 14:21:03 9.9.9.9 - 9.9.9.8 8080 POST /donor/manage_donor.asp - 302 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)

The first POST and the first GET are correct. Then there are (4) more POSTs yet there is not a GET for each of them.

Does anyone know why this may be happening?

Thanks in advance for your time,

Steve DiDomenico
Nashua, NH

 

[Tarwn]

Refresh button on the processing page?

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
Need an expensive ASP developer in the North Carolina area? Feel free to let me know.

 

[sdidomenico]

Nope. No refresh button is avaiable. Look at those date/time entries in the IIS log. Also, all duplicate records for the SQL Server Database insert have date/time stamps within the same second.

 

[Tarwn]

I can't see a logical reason the form would be sent multiple times. If your using javascript or something like that to disable the submit button, it's possible that it isn't running on someones machine. Try crashing the app (browser, whatever) out after a submit and reloas it, see what happens.

Honestly this is goingto be one of those things that is near impossible to figure out without source code and a lot of time trying to duplicate it. i could continue to guess but even to me these are pretty far off sounding guesses.

-T

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
Need an expensive ASP developer in the North Carolina area? Feel free to let me know.

 

[sdidomenico]

Thanks for the input.