Skip to main content
S
SOSO_CODER
Participant
January 14, 2013
Question

Form info sent to both an email and a database

  • January 14, 2013
  • 1 reply
  • 516 views

Someone know a good code that will allow a web base form be sent to an email and also a database?

    This topic has been closed for replies.

    1 reply

    WolfShade
    WolfShade
    Legend
    January 14, 2013

    It's a simple matter to code.  Use both CFMAIL and CFQUERY on the same processing page.

    ^_^

    S
    SOSO_CODERAuthor
    Participant
    January 14, 2013

    Hi Wolfshade, thankyou for looking at my question, as my name indicates I am not a great coder so if you could post a sample of using both on the processing page I would really appreciate it

    WolfShade
    WolfShade
    Legend
    January 14, 2013

    If you want it sent to a static email address:

    <cfmail to="sendtouser@domain.com" subject="Email Form Data">

      #form.field1#

      #form.field2#

      ...

      #form.fieldn#

    </cfmail>

    <cfquery name="insertData" datasource="#yourDSN#">

      INSERT into tableA(columnA, columnB, columnC, columnD)

      VALUES(<cfqueryparam value="#form.field1#" cfsqltype="CFSQLVARCHAR">,<cfqueryparam value="#form.field2#" cfsqltype="CFSQLVARCHAR">,

                   <cfqueryparam value="#form.field3#" cfsqltype="CFSQLDATETIME">,<cfqueryparam value="#form.field4#" cfsqltype="CFSQLINTEGER">)

    </cfquery>

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices