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.