Karen,
Is there any reason that you couldn't use the CFMail tag in the same cf
page that inserts the form fields into the data?
It would look like this:
---user submits form---
<cfquery...> (or cfinsert)
Insert into...
</cfquery>
<cfmail to=#form.to# from=#form.From# cc=#form.CC#>
this is an automatic notification that the database has been updated!
</cfmail>
I would recommend that you do the mail message after the insert (or update)
so that if the db operation fails, the message doesn't get sent
prematurely. We currently do something almost exactly like this - except
that we don't always use form variables for the from,to,...etc.
hth,
Kevin
At 10:04 AM 4/13/00 -0400, you wrote:
>Hi,
>
>I have a form right now that updates a database in CF. I would like for
>an automatic email notification to occur after the database has been
>updated. The "to, from and cc" fields would be included in the update
>form. Currently, we are using a form2email perl script for email
>notification. I am not familiar with CFMail. Any ideas how this could
>be accomplished within one form?
>
>Thanks!
>Karen
--------------------------
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
