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