In short..no it's not meant for what you're doing.
Try this for the sending mail if insert flys:
1) after insert..do a SELECT to determine if the new record is in the DB (mabye just
by determining
if insert query exists) <cfif IsDefined("MyInsertQueryName")>
2) If the new record is there..send your mail.
Now as far as not inserting data unless an e-mail is sent.....
Well an e-mail can send but still not get delivered, so I wouldn't use successful mail
sending as a
mission critical trigger of any kind...but hey..what do I know ;-)
HTH
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 12:58 PM
Subject: Re: Better Javascript/DHTML Calender!
> Is cftransaction only to be used with queries or can you use it in
> conjunction with other things? I'm inserting data into the database and
> then emailing that data to a client but I don't want the insert to occur
> if the e-mail fails and I don't want the e-mail to be sent if the insert
> fails. I've only used cftransaction with blocks of queries.\
>
> Thanks
>
> Michael Corrigan
> Programmer
> Endora Digital Solutions
> 1900 S. Highland Avenue, Suite 200
> Lombard, IL 60148
> 630/627-5200 x-136
> 630/627-5255 Fax
>
>
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
