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/
========================================================================
