I am currently transitioning from using R:Mail 2.6 to R:Mail 3.0 and have run into a bit of a problem that needs to be resolved.

Under version 2.6, I output various components into a single text file that is submitted to R:Mail 2.6. Among the items I add to the single text file are some HTML fragments that are result of SELECT ... HTML statements.

Under version 3.0, I need to use ADD_TO_MESSAGE_BODY followed by content to be added. (e.g. PLUGIN RMail30_75.rbl 'v1|ADD_TO_MESSAGE_BODY <div>Seasons Greetings from all of us at MyISP! </div>') One way I can do this well is to have the content in a variable.

However, what I do not know how to do is to store the result of SELECT ...HTML into a variable (hopefully varchar).

Is there a way I could do this?

Thanks in advance,

James Kim



--
This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.


Reply via email to