Sending Plain Text with Persits

[JohannIcon]

Dear All,

I am building a mailing list component, and I am giving the user the option to receive either HTML or Plain mail. With HTML mail, I have no problems, the problems arise with the Plain mail. My problem is that it is only sending the last article I add instead of all the articles in the database. This is my code:-

'if Plain Text
sqlSelectPlain="select * from Articles where issueID=" & issueID & " order by articleid"
set rsEmailsPlain=cnnMail.execute(sqlSelectPlain)
do while not rsEmailsPlain.eof
Title = rsEmailsPlain("articletitle&quot
Text = KillBr(rsEmailsPlain("articletext&quot)
Line = "-------------------------------------------------------------------------------------------------------------------------------"
PlainText = Title & &quot;<p>&quot; & Text & &quot;<p>&quot; & Line
rsEmailsPlain.movenext
PlainText = KillBr(PlainText)
PlainText = KillP(PlainText)
loop
set rsEmailsPlain=nothing


How can I make it to retreive all the titles and articles which are relevant to this issue and send them?

Thanks for your help

 

[JamesLean]

In the loop, you are not adding the next record to your varaible, you are replacing it! Just add this to your code:

[tt]PlainText = PlainText & &quot;<p>&quot; & Title & &quot;<p>&quot; & Text & &quot;<p>&quot; & Line[/tt] --James

 

[JohannIcon]

Uppppssss! Thanks mate that did the trick!