sp_OASetProperty

[dky1e]

Syntax
sp_OASetProperty objecttoken,
propertyname,
newvalue
[ , index... ]


Is there a 4k character limit the number of characters that can be passed in as the new value?

I want to send out emails by passing in the email string into the parameter, what are my other solutions?

 

[dky1e]

This is interesting.

I am using this component to send email:

http://www.serverobjects.com/comp/AspQMail.htm

If I do the below, what seems keep on changing the property value, the values are actually appended letting me go past the 4K limit. Is it a sql server feature/bug or is it part of the AspQMail?


code snippet...

while exists( select 1 from @tmpMsg )
begin

select top 1
  @MsgId = MsgId,
  @MsgBody = MsgBody
from @tmpMsg
		
--if i keep on doing this for every record in my @tmpMsg table the BodyText property actually keeps on appending	
exec @hr = sp_OASetProperty  @objServer, 'BodyText', @MsgBody
if @hr <> 0 goto ABT

delete from @tmpMsg where MsgId = @MsgId
	
end

Any logic to this mess??