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:
Multiple Pulldowns (1997)
lookup and two records? (1997)
MySQL Wildcard Trouble (2006)
Initiating NewCart (1997)
webcat restarting script on Linux? (1999)
First postarg not taking in $Commands (1997)
WebMerchant 1.6 and SHTML (1997)
WebCatalog complains that the service is not running. (1998)
Re:Merging databases (1997)
Searchable WebCat (etc.) Docs ? (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Can't add a field (1998)
Store Builder, technical infos (1998)
Search inside Include (1998)
Only charge card when product shipped ? (1997)
Bug Report, maybe (1997)
Help! Missing [showif] or [hideif] (2000)
2 Questions (2001)
Configuring E-mail (1997)
Forcing price recalculation in shopping cart (1998)