How do I save Frontpage form data to SQL database and send email.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to "send form results in an email" and how to "save Frontpage form
data to SQL database" but don't know how to do both together when a form is
submitted. Please advise.
 
Ann said:
I know how to "send form results in an email" and how to "save Frontpage
form
data to SQL database" but don't know how to do both together when a form
is
submitted. Please advise.
Click to expand...

Stack the form.

Normally it is:

FORM --> submision script (SQL _or_ email) --> confirmation

To stack them do this:

FORM --> submission script (SQL) --> FORM --> submission script (email) -->
confirmation

Basically, your confirmation page has a copy of the first form only with
different form properties. The user never sees the second form so you can
make it very plain. The data gets handled twice, allowing you to do things
like split off a few fields and email them while the bulk goes to the SQL
database.
 
OK I think I know what you mean when you say to stack them but I don't know
the coding well enough to know where to insert the 2nd Form.
Here is the code for the SQL:
<FORM METHOD="POST" ACTION="--WEBBOT-SELF--" name="FrontPage_Form1">
<!--WEBBOT BOT=SaveDatabase SuggestedExt="asp" S-DataConnection="Complaints"
S-RecordSource="tabCoreComplaints" S-Form-Fields="Trim CoresQty Downtime
CoreD WinderD Grade PM# Pattern OperatorName CoreL CoreDefectDesc CutCores
PMDown PMLoc" S-Form-DBFields="TrimN CoresQty Downtime CoreD WinderD Grade PM
Pattern OperName CoreL CoreDDesc CoresCut MachineD PMLoc"
S-Builtin-Fields="Timestamp REMOTE_USER" S-Builtin-DBFields="EDate EmpVID"
U-ASP-Include-Url="../_fpclass/fpdbform.inc" startspan
--><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include
file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase"
i-checksum="34604" endspan -->
<BLOCKQUOTE>
Here is the code for the Email of the form:
<FORM METHOD="POST" ACTION="--WEBBOT-SELF--" name="FrontPage_Form1">
<!--WEBBOT BOT=SaveResults S-Email-Address="(e-mail address removed)"
S-Email-Format="TEXT/PRE" startspan
--><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--webbot
bot="SaveResults" i-checksum="43374" endspan -->
<BLOCKQUOTE>

Would you mind merging them for me? I'm not sure of right place to merge
them.
 
See http://support.microsoft.com/default.aspx?scid=kb;en-us;275251

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I know how to "send form results in an email" and how to "save Frontpage form
| data to SQL database" but don't know how to do both together when a form is
| submitted. Please advise.
| --
| Ann
 
Uhm. No coding.

Just do this. Make a file form.htm.

Make a confirmation page thankyou.htm

Make your form in form.htm.

Set properties to the SQL submission.

Make another form, file form2.htm.

Copy the entire contents of form.htm into form2.htm (Or just save as to
create it in the step above)

Set properties to email.

Set properties to thankyou.htm.

HERE IS THE ONLY DIFFERENT PART:

set "confirmation page" in form.htm to be form2.htm.

Done.

When a user submits, both forms get executed, once with SQL, once with
email.
 
Thank you - I will give this a try.
--
Ann


Ratatooie said:
Uhm. No coding.

Just do this. Make a file form.htm.

Make a confirmation page thankyou.htm

Make your form in form.htm.

Set properties to the SQL submission.

Make another form, file form2.htm.

Copy the entire contents of form.htm into form2.htm (Or just save as to
create it in the step above)

Set properties to email.

Set properties to thankyou.htm.

HERE IS THE ONLY DIFFERENT PART:

set "confirmation page" in form.htm to be form2.htm.

Done.

When a user submits, both forms get executed, once with SQL, once with
email.
Click to expand...
 
I tried the below to send an email after a user submits their reservation
information, which I would like to be saved in a db (so it can return a
unique receipt number), however when I submit the form it goes to my form2
and does not show the confirmation page nor does it update the db.

Can anyone suggest what I may have done wrong or missed?

Thanks
Ember

:

Uhm. No coding.

Just do this. Make a file form.htm.
Make a confirmation page thankyou.htm
Make your form in form.htm.
Set properties to the SQL submission.
Make another form, file form2.htm.
Copy the entire contents of form.htm into form2.htm (Or just save as to
create it in the step above)
Set properties to email.
Set properties to thankyou.htm.

HERE IS THE ONLY DIFFERENT PART:
set "confirmation page" in form.htm to be form2.htm.
Done.
When a user submits, both forms get executed, once with SQL, once with email.
 
Thanks, seen and tried your first link - no luck in what I was trying to do.

Not seen your second link - it contains formatting that I have tried, but
gives more explanations so perhaps I had some code wrong. I will take a
closer look.

Ember

Thomas A. Rowe said:
The following applies to FP2000 and up:

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

http://quadcomm.com/tips/sendCDOSYSmail.asp

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


Ember said:
Thanks! Seen and tried that one.

Ember
Click to expand...
Click to expand...
 
Make sure that all of your pages that process the form data have a .asp extension and that you are
testing the form via http://www.yourdomainname.com/formname.asp


--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


Ember said:
Thanks, seen and tried your first link - no luck in what I was trying to do.

Not seen your second link - it contains formatting that I have tried, but
gives more explanations so perhaps I had some code wrong. I will take a
closer look.

Ember

Thomas A. Rowe said:
The following applies to FP2000 and up:

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

http://quadcomm.com/tips/sendCDOSYSmail.asp

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


Ember said:
Thanks! Seen and tried that one.

Ember

:

See http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=54
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/

I tried the below to send an email after a user submits their reservation
information, which I would like to be saved in a db (so it can return a
unique receipt number), however when I submit the form it goes to my
form2
and does not show the confirmation page nor does it update the db.

Can anyone suggest what I may have done wrong or missed?

Thanks
Ember

:

Uhm. No coding.

Just do this. Make a file form.htm.
Make a confirmation page thankyou.htm
Make your form in form.htm.
Set properties to the SQL submission.
Make another form, file form2.htm.
Copy the entire contents of form.htm into form2.htm (Or just save as to
create it in the step above)
Set properties to email.
Set properties to thankyou.htm.

HERE IS THE ONLY DIFFERENT PART:
set "confirmation page" in form.htm to be form2.htm.
Done.
When a user submits, both forms get executed, once with SQL, once with
email.
Click to expand...
Click to expand...
Click to expand...
 
They do, and I test from the live site...is that the same?

Ember

Thomas A. Rowe said:
Make sure that all of your pages that process the form data have a .asp extension and that you are
testing the form via http://www.yourdomainname.com/formname.asp


--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


Ember said:
Thanks, seen and tried your first link - no luck in what I was trying to do.

Not seen your second link - it contains formatting that I have tried, but
gives more explanations so perhaps I had some code wrong. I will take a
closer look.

Ember

Thomas A. Rowe said:
The following applies to FP2000 and up:

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251

http://quadcomm.com/tips/sendCDOSYSmail.asp

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


Thanks! Seen and tried that one.

Ember

:

See http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=54
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/

I tried the below to send an email after a user submits their reservation
information, which I would like to be saved in a db (so it can return a
unique receipt number), however when I submit the form it goes to my
form2
and does not show the confirmation page nor does it update the db.

Can anyone suggest what I may have done wrong or missed?

Thanks
Ember

:

Uhm. No coding.

Just do this. Make a file form.htm.
Make a confirmation page thankyou.htm
Make your form in form.htm.
Set properties to the SQL submission.
Make another form, file form2.htm.
Copy the entire contents of form.htm into form2.htm (Or just save as to
create it in the step above)
Set properties to email.
Set properties to thankyou.htm.

HERE IS THE ONLY DIFFERENT PART:
set "confirmation page" in form.htm to be form2.htm.
Done.
When a user submits, both forms get executed, once with SQL, once with
email.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top