Re: A little help on e-mail (HELP!!! :-) )
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19200
interpreted = N
texte = >How can I get the E-MAIL field contents to be picked up from the database >and become the e-mail address that mail is sent to??We finally hashed this out, and in case anyone is curious, the all-important missing part of his question was this:I want to send one email per *lineitem*, and the address of who to send it to is a field called [E-MAIL] in my *product database*This is a cool idea, but since it was somewhat unusual, none of the helpful people on this list could figure out why it was so difficult. Here's the answer, based on ThankYou.tpl from GeneralStore:[LineItems] [include file=Fulfillment.txt&v.email=[E-MAIL]] [/LineItems]Notice the [E-MAIL] field comes from the product database, and is automatically looked up based on the sku of the lineitem. In this case, each item in the product database belongs to a different vendor, and this is how they are notified that someone wants to buy their stuff.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>How can I get the E-MAIL field contents to be picked up from the database >and become the e-mail address that mail is sent to??We finally hashed this out, and in case anyone is curious, the all-important missing part of his question was this:I want to send one email per *lineitem*, and the address of who to send it to is a field called [E-MAIL] in my *product database*This is a cool idea, but since it was somewhat unusual, none of the helpful people on this list could figure out why it was so difficult. Here's the answer, based on ThankYou.tpl from GeneralStore:
[lineitems] [include file=Fulfillment.txt&v.email=[E-MAIL]] [/LineItems]Notice the [E-MAIL] field comes from the product database, and is automatically looked up based on the sku of the lineitem. In this case, each item in the product database belongs to a different vendor, and this is how they are notified that someone wants to buy their stuff.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Grouping fields problem (1998)
2.0 Info (1997)
Math Problem - Format? (1997)
RE: (1997)
Trigger Error (2001)
Credit Card Number checking (1997)
WebDNA v5 Array Q (2003)
Nested tags count question (1997)
Buying sans cart (1997)
Deleting with contexts (2001)
Problems passing [SKU] with $Replace in 2.0 (1997)
WC1.6 to WC2 date formatting (1997)
Monitor Hard Disk Space? (2003)
possible, WebCat2.0 and checkboxes-restated (1997)
Error Lob.db records error message not name (1997)
Problem searching bw & ne of a word (1999)
Quit revisited (1997)
Navigator 4.0 & tables (1997)
Multiple catalog databases and showcart (1997)
WebCatalog can't find database (1997)