Using SQLServer ???? You could try SQLMail (yuck!) with a trigger ...
~Justin
----- Original Message -----
From: Kevin Marshall <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 13, 2000 5:36 PM
Subject: Re: DB update with email notification
> 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.
>
>
------------------------------------------------------------------------------
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.
