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:
Search Engine questions ... (2002)
Serious bug writing to a database ... (2002)
Not really WebCat (1997)
Emailer (1997)
Shopping Cart w/Multiple Databases (1998)
View order not right (1997)
Looking for a Manual (1997)
What happened to the archives? (1999)
NumFound (1999)
[WebDNA] sales tax on shipping (2008)
[OT] (waaaay OT) (2004)
[WebDNA] Apple nixes Mac OS Server ("websites") and other (2018)
Link with [cart] in db field (1999)
emailer (1997)
Quick Question (1997)
Large databases in WebCat (1997)
[WebDNA] OT: Indexing PDF on iTools / apache2 (2008)
Shipping charge question (2003)
FEA REQ: One .hdr, multiple .db's (2003)
WebDNA Solutions ... sorry! (1997)