form posting to a database and e-mail address?

S

steven

I'm new to the web designing and frontpage. I can build a form and have it
post to a db. But i want to have a notification when someone posts to the
database? Like maybe post to the db and e-mail me? what and how would change
to have a dual output?
 
S

Stefan B Rusynko

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'm new to the web designing and frontpage. I can build a form and have it
| post to a db. But i want to have a notification when someone posts to the
| database? Like maybe post to the db and e-mail me? what and how would change
| to have a dual output?
 
S

steven

Okay created the email.asp- but it is having problems with the insert command
for the result table within the mdb. I am trying to test locally with the xp
iis. with no success..here is the email.asp snippet:

mySQL= "INSERT INTO Results "
mySQL= mySQL & "(FirstName,LastName,Division,Requseter,Emailaddress,) "
mySQL= mySQL & "VALUES ('" & Request.Form("FirstName") & "','"
mySQL= mySQL & Request.Form("LastName") & "'"
mySQL= mySQL & ",'" & Request.Form("Division") & "'"
mySQL= mySQL & ",'" & Request.Form("Requester") & "','"
mySQL= mySQL & Request.Form("Emailaddress") & "','"
 
D

David Berry

You have extra commas at the end of your field name list and at the end of
your values. After the last line in your SQL Statement add:

Response.Write mySQL
Response.End

then look at the page in your browser and it will show you what the SQL
String is. Then you can copy and paste this into a Query in MS Access
(switch to SQL View) to see if it works. Once it's working delete those 2
lines


steven said:
Okay created the email.asp- but it is having problems with the insert
command
for the result table within the mdb. I am trying to test locally with the
xp
iis. with no success..here is the email.asp snippet:

mySQL= "INSERT INTO Results "
mySQL= mySQL & "(FirstName,LastName,Division,Requseter,Emailaddress,) "
mySQL= mySQL & "VALUES ('" & Request.Form("FirstName") & "','"
mySQL= mySQL & Request.Form("LastName") & "'"
mySQL= mySQL & ",'" & Request.Form("Division") & "'"
mySQL= mySQL & ",'" & Request.Form("Requester") & "','"
mySQL= mySQL & Request.Form("Emailaddress") & "','"





Stefan B Rusynko said:
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'm new to the web designing and frontpage. I can build a form and have
it
| post to a db. But i want to have a notification when someone posts to
the
| database? Like maybe post to the db and e-mail me? what and how would
change
| to have a dual output?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top