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 eachorder placed. In the normal course of things, when I want to advertise asale, 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 inorders.db, orders again. So, now she has two records in orders.db. Two weekslater, 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 thefirst one it encounters? Or, does WebCat somehow write the summed emails toa 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 thesale records first or last, so that the emails will be sent correctly...Will StarckNovaDermskin care sciencehttp://www.novaderm.com-techs@novaderm.com800-378-1740800-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 eachorder placed. In the normal course of things, when I want to advertise asale, 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 inorders.db, orders again. So, now she has two records in orders.db. Two weekslater, 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 thefirst one it encounters? Or, does WebCat somehow write the summed emails toa 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 thesale records first or last, so that the emails will be sent correctly...Will StarckNovaDermskin care sciencehttp://www.novaderm.com-techs@novaderm.com800-378-1740800-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:
WebCatalog for guestbook ? (1997)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
[WebDNA] Generating Excel File Via WebDNA (2010)
RE: NewCart+Search with one click ? (1997)
Running _every_ page through WebCat ? (1997)
WebStar 3 crackable !!!! (1998)
Missing Links (2000)
Sorry I didn't pay attention-but ??? (1997)
Re:quit command on NT (1997)
Date Range search (1997)
I forgot (1998)
[WebDNA] AC paymethod is missing (2008)
Search group and ww (2003)
Authenticate (1997)
Emailer (1997)
Working with framesets (1998)
Paranoid about serial numbers...not (1998)
WebCat2 - many [carts] on one template page? (1997)
WebCat2b15MacPlugin - [protect] (1997)
[format xs] freeze (1997)