Hi Tom,
I see, you have a specific application and stuff in mind. I see where you
are coming from. Looks like fun.
Regards,
Ali
----- Original Message -----
From: "Tom Langer" <[EMAIL PROTECTED]>
To: "inFusion Support List" <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2001 6:24 PM
Subject: Re: [iMS] imsMail COM Object in SQL7
> There's more than 1 way to skin a cat - so at times, yes.
>
> I am creating a set of business rules in my sql database - the sql
database
> serves several applications, some are VB based, others are CF based. Both
> VB and CF applications are order entry (or related) applications, and both
> have certain customer interaction routines that are being built into it.
>
> As an example: If an order status changed from 1 value to another value,
I
> want an email sent to the customer.
> This is easily enough done in vb, or in CF (so easy in CF). But in
> establishing a good set of business rules on the back end, I do certain
> things in triggers, stored procedures, etc..
>
> If I have it my way - simply changing a status in the raw table, would
fire
> off a trigger which would send email to the customer - I don't have to
rely
> on the client application. This is definitely a 3-tier approach to a
> system - and it keeps things really simple.
>
> When I create an order (in the vb or cf system), I just call a stored
> procedure that plops all necessary data in the proper tables, and if I
need
> to make a change, I do it only in the 1 stored procedure, not the 2 (or
> more) applications.
>
> Besides all this stuff... SQL can execute things much faster than CF can -
> so doing a query of 10,000 customers, and then sending an email to all of
> them, would certainly get done quicker in SQL than CF (in theory, I
haven't
> yet proven this!) - but considering network throughout for CF to obtain a
> recordset, this takes time. The ability to call a CFX tag in CF vs. a com
> object in a SP - I don't see SQL being any slower (if anything faster??)..
>
> If you or anyone has any other questions fire away :-)
>
> Tom Langer
>
> ----- Original Message -----
> From: Ali Jaffrey <[EMAIL PROTECTED]>
> To: inFusion Support List <[EMAIL PROTECTED]>
> Sent: Wednesday, January 10, 2001 5:13 PM
> Subject: Re: [iMS] imsMail COM Object in SQL7
>
>
> >
> > Tom,
> >
> > Is their any significant benefit using SQL server rather than cold
fusion?
> >
> > --Ali
> >
> >
> > ----- Original Message -----
> > From: "Tom Langer" <[EMAIL PROTECTED]>
> > To: "inFusion Support List" <[EMAIL PROTECTED]>
> > Sent: Wednesday, January 10, 2001 3:47 PM
> > Subject: Re: [iMS] imsMail COM Object in SQL7
> >
> >
> > > I was hoping someone had some idea of the sql usage.
> > >
> > > is it possible to make it a single parameter instead of 2??
> > >
> > > EXEC @hr = sp_OASetProperty @object, 'smtpto','[EMAIL PROTECTED]'
> > > EXEC @hr = sp_OASetProperty @object, 'setHeader_To','[EMAIL PROTECTED]'
> > >
> > > If you added a bunch more properties, instead of using the properties
> > > collection, then it would be a little more compatible with something
> like
> > > SQL :-)
> > >
> > > Either that, or make the SetHeader and GetHeader a method that returns
a
> > > value
> > >
> > > x = GetHeader("To")
> > > this returns whatever the To header is set to
> > > or
> > >
> > > x = SetHeader("To","[EMAIL PROTECTED]")
> > > this woudl set the To header to [EMAIL PROTECTED], doesn't need to
> return
> > > anything.
> > >
> > > So, if GetHeader and SetHeader are methods, SQL could use them without
a
> > > problem, and would be used very similar to the way you are doing it
now
> > (but
> > > you seem to be using a property collection, which again, sql doesn't
> seem
> > to
> > > support).
> > >
> > > My input - hopefully it's possible!
> > >
> > > cya
> > >
> > > Tom
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: Howie Hamlin <[EMAIL PROTECTED]>
> > > To: inFusion Support List <[EMAIL PROTECTED]>
> > > Sent: Wednesday, January 10, 2001 2:39 PM
> > > Subject: Re: [iMS] imsMail COM Object in SQL7
> > >
> > >
> > > > According to the manual (yes, it's not much of a manual as of yet)
the
> > > > function is as follows:
> > > >
> > > > Procedure Params Description
> > > > SetHeader Strings A header name and value pair
> > > >
> > > > This equates to something like: SetHeader(headername,value)
> > > >
> > > > A ColdFusion example:
> > > >
> > > > <cfset myobj.setheader("To","[EMAIL PROTECTED]")>
> > > >
> > > > An ASP example:
> > > >
> > > > Mail.setheader "To","[EMAIL PROTECTED]"
> > > >
> > > > As far as the syntax for SQL Server - I have no clue, sorry.
> > > >
> > > > Regards,
> > > >
> > > > Howie
> > > >
> > > > ----- Original Message -----
> > > > From: "Tom Langer" <[EMAIL PROTECTED]>
> > > > To: "inFusion Support List" <[EMAIL PROTECTED]>
> > > > Sent: Wednesday, January 10, 2001 3:07 PM
> > > > Subject: Re: [iMS] imsMail COM Object in SQL7
> > > >
> > > >
> > > > > ok, one more problem - this one doesn't seem to be a typo, but
> rather
> > > some
> > > > > syntax.
> > > > >
> > > > > SQL is not liking any way of setting the setHeaders, maybe because
> > it's
> > > a
> > > > > property in a collection???
> > > > >
> > > > > Here are the lines I'm trying..
> > > > >
> > > > > (this one I expect to fail, but I had to try setproperty anyways)
> > > > > EXEC @hr = sp_OASetProperty @object, 'setHeader',
> > > '[EMAIL PROTECTED]',
> > > > 1
> > > > > select @hr as 'hdto'
> >
> > > > >
> > > > > (this one I can understand why it would fail, afterall, setHeader
is
> > not
> > > a
> > > > > method)
> > > > > EXEC @hr = sp_OAMethod @object, 'setHeader', 'To',
> > > '[EMAIL PROTECTED]'
> > > > > select @hr as 'hd_to'
> > > > >
> > > > >
> > > > > I know the sp_OAMethod is working, the email is getting sent
> > (hooray!),
> > > > but
> > > > > I can't sent any of the headers.
> > > > >
> > > > > Is this a) bad sql syntax? or b) a com object incompatibility?
> > > > >
> > > > > hmmm
> > > > >
> > > > > Tom
> > > > >
> > > > > ----- Original Message -----
> > > > > From: Howie Hamlin <[EMAIL PROTECTED]>
> > > > > To: inFusion Support List <[EMAIL PROTECTED]>
> > > > > Sent: Wednesday, January 10, 2001 2:07 PM
> > > > > Subject: Re: [iMS] imsMail COM Object in SQL7
> > > > >
> > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Tom Langer" <[EMAIL PROTECTED]>
> > > > > > To: "inFusion Support List" <[EMAIL PROTECTED]>
> > > > > > Sent: Wednesday, January 10, 2001 2:57 PM
> > > > > > Subject: Re: [iMS] imsMail COM Object in SQL7
> > > > > >
> > > > > >
> > > > > > > ok - Thanks Howie. I am now officially humiliated! :-(
> > > > > > >
> > > > > >
> > > > > > Glad I could be of service <g>
> > > > > >
> > > > > > > Yeah, that was the problem.. This is what happens when you
jump
> > the
> > > > > gun..
> > > > > > >
> > > > > >
> > > > > > I jump the gun all too often myself...
> > > > > >
> > > > > > > Also a correction - I misunderstood this thus messing up my
code
> > and
> > > > > > > structure of it badly.
> > > > > > >
> > > > > > > 0 = Success
> > > > > > > non-0 = Failure
> > > > > > >
> > > > > >
> > > > > > Yes, that's correct...
> > > > > >
> > > > > > > After I *test* the code out a little more, I'll send over the
> > > working
> > > > > code
> > > > > > > set.
> > > > > > >
> > > > > >
> > > > > > Thanks - much appreciated.
> > > > > >
> > > > > > Regards,
> > > > > >
> > > > > > Howie
> > > > > >
> > > > > > > Tom
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > >
========================================================================
> > > > > > This list server is Powered by iMS
> > > > > > 'The Swiss Army Knife of Mail Servers'
> > > > > > --------------------------------------
> > > > > > To leave this list please complete the form at
> > > > > > http://www.coolfusion.com/iMSSupport.cfm
> > > > > > Need an iMS Developer license? Sign up for a free license here:
> > > > > > http://www.coolfusion.com/iMSDevelopers.cfm
> > > > > > List archives:
> > > http://www.mail-archive.com/infusion-email%40eoscape.com/
> > > > > >
> > >
========================================================================
> > > > > >
> > > > >
> > > > >
> > > > >
> > ========================================================================
> > > > > This list server is Powered by iMS
> > > > > 'The Swiss Army Knife of Mail Servers'
> > > > > --------------------------------------
> > > > > To leave this list please complete the form at
> > > > > http://www.coolfusion.com/iMSSupport.cfm
> > > > > Need an iMS Developer license? Sign up for a free license here:
> > > > > http://www.coolfusion.com/iMSDevelopers.cfm
> > > > > List archives:
> > http://www.mail-archive.com/infusion-email%40eoscape.com/
> > > > >
> > ========================================================================
> > > > >
> > > >
> > > >
> > > >
> ========================================================================
> > > > This list server is Powered by iMS
> > > > 'The Swiss Army Knife of Mail Servers'
> > > > --------------------------------------
> > > > To leave this list please complete the form at
> > > > http://www.coolfusion.com/iMSSupport.cfm
> > > > Need an iMS Developer license? Sign up for a free license here:
> > > > http://www.coolfusion.com/iMSDevelopers.cfm
> > > > List archives:
> http://www.mail-archive.com/infusion-email%40eoscape.com/
> > > >
> ========================================================================
> > > >
> > >
> > >
> > >
========================================================================
> > > This list server is Powered by iMS
> > > 'The Swiss Army Knife of Mail Servers'
> > > --------------------------------------
> > > To leave this list please complete the form at
> > > http://www.coolfusion.com/iMSSupport.cfm
> > > Need an iMS Developer license? Sign up for a free license here:
> > > http://www.coolfusion.com/iMSDevelopers.cfm
> > > List archives:
http://www.mail-archive.com/infusion-email%40eoscape.com/
> > >
========================================================================
> > >
> >
> >
> > ========================================================================
> > This list server is Powered by iMS
> > 'The Swiss Army Knife of Mail Servers'
> > --------------------------------------
> > To leave this list please complete the form at
> > http://www.coolfusion.com/iMSSupport.cfm
> > Need an iMS Developer license? Sign up for a free license here:
> > http://www.coolfusion.com/iMSDevelopers.cfm
> > List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> > ========================================================================
> >
>
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.coolfusion.com/iMSSupport.cfm
> Need an iMS Developer license? Sign up for a free license here:
> http://www.coolfusion.com/iMSDevelopers.cfm
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
>
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
