You can download a sample from:
ftp://ftp.coolfusion.com/pub/ods/ims/TriggerSample.sql
There is some text at the top of this that needs to be edited out. It was
written by an iMS coder named Tom Langer.
HTH,
Howie
----- Original Message -----
From: "Bob Silverberg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 9:47 AM
Subject: RE: CFMAIL limits
> Howie,
>
> This is exactly what we need to do for a project (send customized emails
via
> a SQL Server trigger). We haven't started research on it yet, so if you
can
> provide or direct us to any info/sample code on this technique it would be
> greatly appreciated.
>
> Thanks,
> Bob
>
> -----Original Message-----
> From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
> Sent: March 26, 2001 10:11 PM
> To: CF-Talk
> Subject: Re: CFMAIL limits
>
>
> There's a neat solution that a client of ours uses (please - before
flaming
> me the solution I'm offering is currently free). He uses an SQL server
> trigger to process mail using our mail sending engine and our iMSMail COM
> object (of course, you can also use our cfx_iMSMail tag as well). Anyway,
> the idea is:
>
> 1 - install the free iMS POST-SE server
>
> 2 - install the iMSMail COM object
>
> 3 - use a purely SQL solution with triggers to create a custom email to
send
> to your clients using the COM object -or- use a CF solution with the
> CFX_iMSMail tag to send the mail.
>
> You can download iMS POST-SE for free until the end of this month from:
>
> www.coolfusion.com/imspromo.cfm
>
> HTH,
>
> Howie Hamlin - inFusion Project Manager
> On-Line Data Solutions, Inc.
> www.CoolFusion.com
> 631-737-4668 x101
> inFusion Mail Server (iMS) - the World's most configurable mail server
> Get your free copy of iMS POST-SE Server from CoolFusion!
>
> ----- Original Message -----
> From: "tom muck" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, March 26, 2001 5:08 PM
> Subject: CFMAIL limits
>
>
> > Has anyone run into any limitation on the quantity of emails that can be
> > sent out with CFMAIL? I need to send out personalized bills to clients
> > that could have one to several hundred line items inside the body of the
> > email, and there could be as many as 100,000 - 200,000 emails at a time.
> > I've run tests up to 1000 with no problems, but I'm wondering if there
is
> a
> > point where the server might timeout. I'm running SQL Server as the
> > database. Any thoughts?
> >
> > tom
> >
> >
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
