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

On May 11, 10:08 pm, "Henry Flash" <webforumsu...@macromedia.com>
wrote:
> 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

If you are a "noob" I would suggest you try to make it simple to start
with and then make it more complex if and when needed.
Start with:
a cfm page with a form (your survey) [1],
a processing cfm page to process your results and store them in DB
[2],
(maybe) a notification page to notify the surveyed about the results
[3]...
Send the link to page [1] via email...

You will need to read
http://livedocs.adobe.com/coldfusion...tml/wwhelp.htm
or
http://livedocs.adobe.com/coldfusion...docs/help.html
or maybe other if you installed older version of CF.

If you expect people here to write complete code for you then they
will expect you to pay for it...

This is a place where people will help you to learn, NOT do your work
for free.

For code examples see CF docs
and
http://www.riaforge.org/

The LiveDoc at http://livedocs.adobe.com/coldfusion...s/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>

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