ml_qa_setbinarycontent

Sets the binary content of the message.

Parameters
Item Description Remarks
1 Message ID VARCHAR(128). You can obtain the message ID from ml_qa_createmessage or ml_qa_getmessage.
2 Content LONG BINARY

You cannot alter this content after the message has been sent.

See also
Example

In the following example, a message is created with encrypted content and sent:

begin
    declare @msgid varchar(128);
    set @msgid = ml_qa_createmessage();
    call ml_qa_setbinarycontent( @msgid, encrypt( 'my secret message', 'mykey' ) );
    call ml_qa_putmessage( @msgid, 'clientid\queuename' );
    commit;
end