Copy link to clipboard
Copied
Hi
I am using a simple nsert statement .The insert statement picks a variable
from the form and inserts it into the database
I have no loops in the page
the code is :
<cfif isdefined("Form.Category")>
<cfquery name="InsertCat" datasource="ShoppingCart">
Insert Into ShoppingMstCategory(Category)
Values '#Form.Category#')
</cfquery>
</cfif>
The insert runs twice on its own.
Though if I use Query analyser to insert the statement only inserts once.
am I missing something. I am using CF 10
Have something to add?