fieldsumm quandary
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37844
interpreted = N
texte = When I add emailsumm=T to a search, how does WebCatalog handle this exactly?The reason I ask is the following:I have a database, orders.db, which contains all of the info regarding each order placed. In the normal course of things, when I want to advertise a sale, a run a search on this db, like so:[search db=orders.db&neemaildata=[blank]&emailsumm=T] [founditems] [sendmail...]Of course the emailsumm=T ensures that only one email is sent per customer.Now, suppose I run a sale. Customer A, whose name is already recorded in orders.db, orders again. So, now she has two records in orders.db. Two weeks later, I want to send out another email advertisement of the sale, but I *don't* want anyone who has already ordered during the sale to get an email.So, my search can change to:[search db=orders.db&neemaildata=[blank]&emailsumm=T] [founditems] [hideif [orderdate]>08/01/2001] [sendmail...]But, I don't know which [email] in the db the fieldsumm chooses. Is it the first one it encounters? Or, does WebCat somehow write the summed emails to a buffer and then spit one out when it's done reading the whole db?If I know exactly how summing works, I can arrange my search to find the sale records first or last, so that the emails will be sent correctly...Will Starck NovaDerm skin care science http://www.novaderm.com -techs@novaderm.com 800-378-1740 800-378-1740------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
When I add emailsumm=T to a search, how does WebCatalog handle this exactly?The reason I ask is the following:I have a database, orders.db, which contains all of the info regarding each order placed. In the normal course of things, when I want to advertise a sale, a run a search on this db, like so:[search db=orders.db&neemaildata=[blank]&emailsumm=T] [founditems] [sendmail...]Of course the emailsumm=T ensures that only one email is sent per customer.Now, suppose I run a sale. Customer A, whose name is already recorded in orders.db, orders again. So, now she has two records in orders.db. Two weeks later, I want to send out another email advertisement of the sale, but I *don't* want anyone who has already ordered during the sale to get an email.So, my search can change to:[search db=orders.db&neemaildata=[blank]&emailsumm=T] [founditems] [hideif [orderdate]>08/01/2001] [sendmail...]But, I don't know which [email] in the db the fieldsumm chooses. Is it the first one it encounters? Or, does WebCat somehow write the summed emails to a buffer and then spit one out when it's done reading the whole db?If I know exactly how summing works, I can arrange my search to find the sale records first or last, so that the emails will be sent correctly...Will Starck NovaDerm skin care science http://www.novaderm.com -techs@novaderm.com 800-378-1740 800-378-1740------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Will Starck
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:
GuestBook example (1997)
[createfolder] & [deletefolder] (1997)
WC2b15 File Corruption (1997)
Tip for making barcharts (1997)
Change to 5.0 per website licensing (2003)
webcat 2.1 new cart fields - please explain more (1998)
Random question (1998)
Here's how to kill a Butler Database. (1997)
webcat method for waiting specific amount of time? (2000)
Product Name in AdminResults.inc (2001)
New Site Announcement (1998)
several people editing a database. (2001)
Error: this shopping cart has already been submitted (2003)
WCS Newbie question (1997)
Pop-up menu (1998)
RE: creating writefile data from a nested search (1997)
Re:quit command on NT (1997)
[WebDNA] How to access WebDNA admin pages? (2010)
Relevancy Rating (1998)
html delivery (1997)