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:

Webcat/Webmerchant part II (1998) bug in [SendMail] (1997) Intermitent problem using [referrer] (1997) SiteGuard Admin Feature ? (1997) Shell Script needed (2003) WebTen? (1997) re: Large databases in WebCat (1997) question: webmerchant connection (1997) SetHeader (1999) cart ID (1998) WebCatalog 4.0.1b1 is now available (2000) SiteEdit Pro, DataBase Helper and Europe (2000) Plugin or CGI or both (1997) WebCatalog can't find database (1997) It just Does't add up!!! (1997) RE: strip .0 off off IPaddress (1998) Generating Report Totals (1997) Linux Beta4 Problem (2000) question about checkboxes (1999) WebCat2 beta 11 - new prefs ... (1997)