1 Reply Latest reply on Dec 1, 2013 1:51 PM by BKBK

    Re: insert statement runs twice in place of once

    fulcrumdesign

      I am using a insert 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 CF10.

       

      Here's the whole page.

       

       

      <html>

      <head>

      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

      <title>cat update</title>

      </head>


      <body>

      <cfif isdefined("Form.Category")>

      <cfquery name="InsertCat" datasource="ShoppingCart">

      Insert Into ShoppingMstCategory(Category)

      Values('#Form.Category#')

      </cfquery>

      <cfelse>

      <cfif isdefined("Form.CategoryEdit")>

      <cfquery datasource="Shoppingcart">

      UPDATE ShoppingMstCategory

      SET

      [Category] = '#Form.Category#'

      WHERE CategoryID = #Form.EditId#

      </cfquery>

      </cfif>

      </cfif>


      </body>

      </html>