K
Kate
How can I get my form to do all three of the above when
the submit button is hit?
Thanks!
the submit button is hit?
Thanks!
Saving form results to a database, displaying as a web page and sending an email
J
Jim Buyens
-----Original Message-----
Download the instructions from MSKB aticle 275251, How to
Send Form Results to a Database and E-mail Address at the
Same Time.
Also, brace yourself. The procedure is 16 pages long, and
involves writing program code.
Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
How can I get my form to do all three of the above when
the submit button is hit?
Download the instructions from MSKB aticle 275251, How to
Send Form Results to a Database and E-mail Address at the
Same Time.
Also, brace yourself. The procedure is 16 pages long, and
involves writing program code.
Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
J
John_Petry
Kate
There are two widely used techniques for doing this, and both are complex, high-maintenance, and error prone. One uses CDONTS and the other, well, let's just say it's a kludge. My experience with both has been bad
Instead, you may want to look at it from a different perspective---the database itself. If you use MS SQL, for example, you can send the form results direclty to the database and then set a trigger in the database to send an e-mail when a row is added. I think MSDE also supports triggers, but I can't recall off-hand. MYSQL was suposed to add triggers in an upcoming release, but again, that's not my area of knowledge
The inablility of FrontPage to be able to send form results simultaneously to a database and e-mail really has to do with incompatable DLLs, and this remains, in my humble opinion, is a huge oversight in the product line. After all, for any e-commerce site, a proprietor would like to know a new order has been placed in the database, and e-mail is a perfect way of sending such a notification. Regardless of which techniques you employ, you'll need patience and some luck!.
There are two widely used techniques for doing this, and both are complex, high-maintenance, and error prone. One uses CDONTS and the other, well, let's just say it's a kludge. My experience with both has been bad
Instead, you may want to look at it from a different perspective---the database itself. If you use MS SQL, for example, you can send the form results direclty to the database and then set a trigger in the database to send an e-mail when a row is added. I think MSDE also supports triggers, but I can't recall off-hand. MYSQL was suposed to add triggers in an upcoming release, but again, that's not my area of knowledge
The inablility of FrontPage to be able to send form results simultaneously to a database and e-mail really has to do with incompatable DLLs, and this remains, in my humble opinion, is a huge oversight in the product line. After all, for any e-commerce site, a proprietor would like to know a new order has been placed in the database, and e-mail is a perfect way of sending such a notification. Regardless of which techniques you employ, you'll need patience and some luck!.