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:

    
  1. Re: fieldsumm quandary (Brian Fries 2001)
  2. fieldsumm quandary (Will Starck 2001)
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:

How to Display text in empty fields (1997) (2003) Universal db access template ... (2002) Sendmail question [Newbie] (1999) Hummm .... (2002) UPS XML (2005) Country & Ship-to address & other fields ? (1997) Caching [include] files ... (1997) A quickie question (1997) CC Processing (2001) Inprovement to listfiles ... (2003) japanese characters (1997) append=T problem (1998) select menus & database design (1998) Search returns all, not 20 (1997) Document contains no data... (1999) international time (1997) WebMerchant Only reads 1.4 order files error (1997) WebDNA Grep assistance [lowercase] (2003) BBEdit and WebCatalog 2.0? (1997)