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