form posting to a database and e-mail address?

[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?

 

[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?

 

[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") & "','"

 

[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

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") & "','"

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?