asked on

Looping Records from Database in HTML Email Notification ASP page

The following piece of code is the only part I can't get to work in my shopping cart email notification. I am trying to pull the items in the cart table of an Access database and submit it in the email with HTML format.

Can anyone see what I am missing here?
Any help will be greatly apreciated.
You may need to copy the code and paste in an editor to see the format.
Gigabandit

DO WHILE NOT cRS.EOF

HTML = HTML &"<tr bordercolor=""#C9C0AB"" bgcolor=""#FFFFFF"">"
HTML = HTML &"<td><div align=""center"">"& cRS("Ctquantity") & "</div></td><td><div align=""center"">" & cRS("Ctsize") & "</div></td><td><div align=""center"">"& cRS("Ctcolor") &"</div></td><td><div align=""center"">"& cRS("Ctembroideropt")&"</div></td><td><div align=""center"">"& cRS("Ctproductname") &"</div></td><td><div align=""right"">"& cRS("Ctproductprice") &"</div></td><td><div align=""right"">"& lineTotal & vbCrLf &"</div></td>"
HTML = HTML &"</tr>"

cRS.MoveNext
loop

ASKER CERTIFIED SOLUTION

drnick

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bhagyesht

Well since i dont have the rS at my place i substuted it with text. the asp code has no error. can you plese tell me what error you are facing?

SOLUTION