I have written code in an asp page which establishes an ADODB connection 

to a SQL Server 7 database.



I then use the addnew method to add a record using querystring parameters 

passed from the previous asp page.



After using the update method, I then close the record set, clear the 

response buffer and redirect the output to a pdf document.



When I check my database, there have been 4 records written to the table 

and not just one. If I change the redirect to another asp page instead of 

the pdf document, it adds just one record as expected.



I have been pulling my hair out over this one. Can anybody help?



Regards,



John M