Re: Search Question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53604
interpreted = N
texte = On Monday, October 27, 2003, at 04:02 AM, Jesse Proudman wrote:> I'm trying to generate a port of all products in my products database > that have never made a sale to date. I can't think of a logical way > to do this...>> The best I've come up so far is:>> 1) Generate Table with All Products> 2) Search Orders Database and summarize based on SKU> 3) In the founditems of this search, do a delete on the table for > every found sku. This will remove all the products that have had > sales.> 4) Search the table and show the results.>> This seems like it could be there quite processor intensive but it's > not an awful idea.>> Any one have a better idea on how to do this?>>How about just running through your products db and for each record check whether there's a sale in your orders db?If there isn't, then list the product.[search...][founditems][lookup...]if not found
[/lookup][/founditems][/search]Mark.-------------------------------------------------------------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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On Monday, October 27, 2003, at 04:02 AM, Jesse Proudman wrote:> I'm trying to generate a port of all products in my products database > that have never made a sale to date. I can't think of a logical way > to do this...>> The best I've come up so far is:>> 1) Generate Table with All Products> 2) Search Orders Database and summarize based on SKU> 3) In the founditems of this search, do a delete on the table for > every found sku. This will remove all the products that have had > sales.> 4) Search the table and show the results.>> This seems like it could be there quite processor intensive but it's > not an awful idea.>> Any one have a better idea on how to do this?>>How about just running through your products db and for each record check whether there's a sale in your orders db?If there isn't, then list the product.[search...][founditems][lookup...]if not found [/lookup][/founditems][/search]Mark.-------------------------------------------------------------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://webdna.smithmicro.com/
Mark Derrick
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:
multiple search commands (1997)
Re:Emailer tracking (1997)
shownext & math (1997)
WC2b12: Yes, Formulas.db is for real (1997)
Emailer error 571 (1998)
Grant, please help me ... (1997)
[WebDNA] a major shift in strategy? (2008)
problems with 2 tags (1997)
There's a bug in the math context ... (1997)
Problems with cybercash (2000)
WebCatalog on Windows 98 (2000)
template cache problem (1998)
Just Testing (1997)
[WebDNA] encrypt files/directories (2011)
[WebDNA] WebDNA Alive! (2012)
Bugs in IE 6.0 ? (2003)
using showpage and showcart commands (1996)
Resume Catalog ? (1997)
Authentication (1998)
A multi-processor savvy WebCatalog? (1997)