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:

Limit on nested [ShowIf]'s? (1997) WC on Mac OS X or Mac OS X Server 2.x (2001) Tax Laws for Online Sales (2003) Show shoppingcart after remove last item (1997) Nested tags count question (1997) [WebDNA] GETCHARS ... words? (2009) WebCat2 - [format thousands] (1997) Can you specify encoding=multiline? (2000) All quiet (2004) WebCatalog Upgrade Pricing? (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) SiteEdit Pro Update Announcement (1997) Major bug report on rootbeer (1997) docs for WebCatalog2 (1997) searchable list archive (1997) WebCatalog NT beta 18 problem (1997) international time (1997) why won't this work, please tell me??? (2001) [PROTECT] Problem (2003)