4 Replies Latest reply: Feb 15, 2011 12:51 PM by OgreOne RSS

    Insert Into DB & Sendmail

    OgreOne Community Member

      BACKGROUND: I had developed a form that when submitted goes to a page to process the formmail.  This works great. The process goes like this (using cflocation each time):

       

      registration 1 > send regisitration 1 > registration 2 > send registration 2 > registration complete.

       

      So, I receive 2 seperate emails for each step of the registration process.

       

      WHAT I WOULD LIKE TO DO: So now, I want to be able to take some of the fields and when the form is submitted to the formmail processing page, to also inter it into a database.  So in DW, I added 'insert form'.  The fileds in the DB are the same as the names of the form fields.  When tested, if the cflocation is pointed to any page other than one of the formmail processors, the data is successfully uploaded to the DB.  However, if the cflocation goes to 'send registration 1', the info is uploaded to the DB, BUT then the webpage shows a "page cannot be found" error, with no CF error information.

       

      Is it possible to do both tasks without having to change my code too much?