Sql record being inserted twice. Don't want it to.

[timtom]

Hi. I've got a simple submit form page which works perfectly, except that it inserts the same record twice (but with different auto ids). It only does this the first time I add a record for a particular company, once the duplicate record is in there I can just add records for that company normally. Why would that be? My code is as follows

[red]<%
option explicit
dim objCn, objRs, sSql
%>
<!--#include file = &quot;../includes/db.asp&quot;-->
<%
dim complaint_id, company_qr, complaint_date, complaint, action
dim training_raised, procedural_raised, date_completed, follow_call

company_qr = session(&quot;COMPANY&quot
complaint_date = request.form(&quot;txtComplaintDate&quot
complaint = request.form(&quot;txtComplaint&quot
action = request.form(&quot;txtAction&quot
training_raised = request.form(&quot;txtTrainingIssue&quot
procedural_raised = request.form(&quot;txtProceduralIssue&quot
date_completed = request.form(&quot;txtDateCompleted&quot
follow_call = request.form(&quot;txtFollowUpCall&quot
call openConnection(objCn)

sSql = &quot;INSERT INTO COMPANY_COMPLAINTS (COMPANY_QR, COMPLAINT_DATE, COMPLAINT, &quot; &_
&quot;ACTION, TRAINING_ISSUE_RAISED, PROCEDURAL_ISSUE_RAISED, DATE_COMPLETED, &quot; &_
&quot;FOLLOW_UP_CALL) VALUES('&quot; & company_qr & &quot;', '&quot; & complaint_date & &quot;', '&quot; &_
complaint & &quot;', '&quot; & action & &quot;', '&quot; & training_raised & &quot;', '&quot; & procedural_raised & &quot;', '&quot; &_
date_completed & &quot;', '&quot; & follow_call & &quot;')&quot;

set objRs = objCn.execute (sSql)

call closeConnection(objCn)
response.redirect &quot;viewcomplaints.asp&quot;
%>[/red]

Or would I be best to post this in the SQL forum? Thanks for help
Cheers
Sarah ;-)

[sub]WASN'T FIT ENOUGH FOR THE POLICE FORCE[/sub]​

 

[smbure]

This looks fine...doesn't seem as if two inserts should be happening. Has this been resolved? gettin' jiggy wid' it --
smbure

 

[chiph]

Are you doing a post-back to this page? Maybe it's inserting again afterwards.

Chip H.

 

[webspy]

whats ur asp page name?where u check the duplicate records for a company?i think u postback to this page in some where.

wrg
webspy