[thelist] Retrieving info from db to ASPMail

[Scott Dexter]

> Do I need to specify the table where each variable is coming from? I
> tried using 'orders_quantity', 'orders_productID' but it doesn't work.
> The sendmail code I am using is as follows:

> " & firstname & lastname  & vbcrlf & "Address: " & street & vbcrlf &
> "City: " & city & vbcrlf & "Province: "  & province & vbcrlf & "Postal
> code: " & postalcode & vbcrlf & "And he placed the following order: "&
> vbcrlf & "Product: " & productID & vbcrlf & "Quantity: " & quantity &
> vbcrlf & "Date: " & now()

I don't see where you are pulling the data out of the db, do you have
that code?

sgd