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:
type 2 errors with ssl server (1997)
REPOST: Large founditems loops (2000)
WebCat2 - Getting to the browser's username/password data (1997)
WebCat2 - many [carts] on one template page? (1997)
Loop code problem (2000)
Feature Request: DB Field manipulation (1998)
Almost a there but..bye bye NetCloak (1997)
Merging databases (1997)
Show if time tags (1997)
E-mailer error codes (1997)
[tcpconnect] doing nothing (2001)
Share cost of training videos! (1998)
Desperatly seeking (2000)
Logical and or in [hideif] (1997)
Mac 2.1b2 speed (1997)
Out of the woodwork (2007)
Nested tags count question (1997)
Information on Vieworders.tpl (1998)
[WebDNA] POP3 mail client in WebDNA (2016)
Secure Web Server (1999)