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>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER