Link to home
Start Free TrialLog in
Avatar of bjv211
bjv211

asked on

Insert Statemtent creating duplicate rows

I have Coldfusion 8.0 and Access Database.   The sql statement is supposed to insert one row into the database.  However, it is acting like it's executing twice and inserting 2 identical rows into the database everytime it runs.  It seems to happen more frequently with IE 7 than others.
<cfquery datasource="internships" name="insertit" result="WhatDID">
INSERT INTO logs (logs_netID,logs_content,logs_datetime,logs_datetime_output,logs_type,logs_week) 
VALUES ('#session.netID#','#Trim(form.content)#',#CREATEODBCDATETIME(Right(form.id,10))#,#CREATEODBCDATETIME(Now())#,'#logtype#',#weeknum#)
</cfquery>

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bjv211
bjv211

ASKER

I love this forum. I've been focusing on the SQL and not the form.  I had setup form buttons to submit onclick.  When I changed them to default submit buttons everything works fine!  Thank you!!