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