Classic ASP Discussion - looping through records in an email

Print Page | Close Window

looping through records in an email

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=5940
Printed Date: 31 March 2026 at 8:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: looping through records in an email

Posted By: amwin
Subject: looping through records in an email
Date Posted: 24 September 2003 at 8:20am

I have written an e-commerce app but am having problems sending a confirmation email to the customer.

I need to list all of the products ordered in the email along with quantity and prices but it only shows the first one.

How do I loop through the products ordered by that customer and display them within the email?

Thanx

Replies:

Posted By: dj air
Date Posted: 24 September 2003 at 2:31pm

with the email set up

i take it your using a db to get the details ... query it,

and use

do while not rs.EOF

strEmailBody = strEmailBody & "<br>New details on new line"

rs.movenext

loop

that should help you with what you want

Posted By: amwin
Date Posted: 25 September 2003 at 6:34am

OK, thanks