Skip to main content
May 11, 2008
Question

Coldfusion e-mail survey

  • May 11, 2008
  • 2 replies
  • 290 views
Hi,

I am absolutely new to CF and need to develop a survey. The survey needs to be sent via e-mail. The recipient then fills in the data to be populated in an Access database. Can anyone point me to any resources online or in books that would help me? As I said, I am a noob. I installed CF developer edition, finally got it to work and have done a few toots. I am very familiar with HTML, Access and SQL.

Thank you,
Henry
    This topic has been closed for replies.

    2 replies

    Inspiring
    May 18, 2008
    Hi Henry,

    Am I reading your post correctly, that you want to distribute the entire survey
    via e-mail? If my reading is correct, then my question is why must it be done
    in this manner.

    My suggestion would be to maintain the survey on the server, distribute an
    e-mail with a hyperlink to the survey for the recipents to complete, which
    also allows for more control over the survey process. Further I would do the
    survey in three parts (pages) as such.

    -- survey_page.cfm
    This page is obvious and would contain the survey questions.

    -- survey_processing.cfm
    This page is where all the processing would take place, like
    inserting responses into the appropriate database(s), as well as
    sending automated e-mail notifications when a survey is received.
    The last line of code on this page would be a <cflocation> tag
    redirecting the individual to the next page. By using a processing
    page, you reduce if not eliminate the double record creation that
    can occur when individuals click the submit button more then once.

    -- survey_completed.cfm
    This page would let the submitter know the submission was completed,
    as well as let you provide any additional information you may want to
    bring to their attention. Could also use this page to provide links to
    thank you gifts, etc. to show appreciation for taking the time to complete
    the survey.

    Anyway just my two cents worth on your post. I have done alot of survey(s)
    and have found this to be the best working process (at least for me).

    Leonard B
    May 15, 2008
    The LiveDoc at http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-p38.htm is pretty thorough...

    For the email part, have something in the head of your page that says <cfif isDefined('form.submit')><cfmail>(email here)</cfmail></cfif>