Re: Search Question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53606
interpreted = N
texte = That sounds like the best move to me too ... at any rate, whenever I need to do somethin 'processor-intensive' I do it on my local machine using my handy dandy free Dev Edition of WebDNA. Then I replace the database on the live server. -Dan On Mon, 27 Oct 2003 12:55:24 +0000 Mark Derrick
wrote: > >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/ ------------------------------------------------------------ http://www.StrongGraphicDesign.com (208) 319-0137 | Toll-free p/f 877-561-1656 ------------------------------------------------------------ ------------------------------------------------------------- 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:
That sounds like the best move to me too ... at any rate, whenever I need to do somethin 'processor-intensive' I do it on my local machine using my handy dandy free Dev Edition of WebDNA. Then I replace the database on the live server. -Dan On Mon, 27 Oct 2003 12:55:24 +0000 Mark Derrick wrote: > >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/ ------------------------------------------------------------ http://www.StrongGraphicDesign.com (208) 319-0137 | Toll-free p/f 877-561-1656 ------------------------------------------------------------ ------------------------------------------------------------- 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/
"Dan Strong"
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:
More WebMerch<->MacAuthoriz (1997)
[OT] Xserve for Web Hosting (2003)
New command suggestion (was Modifying databasesmanually) (1997)
Default admin bug and how tech support reacted to it. (2000)
two unique banners on one page (1997)
Dreamweaver extensions (2000)
Trouble with adding multiple items to cart (1999)
WebCat2b15MacPlugin - [protect] (1997)
looping table rows (1999)
case number with spaces. (2000)
[OT] ODBC between IIS and remote Access problem (2000)
test (2002)
headers (2004)
Not really WebCat (1997)
Separate SSL Server (1997)
Moving a record from one dataabse to another. (2000)
Now when I send TeaRoom Order fields it does not post in Invoice. (1997)
WebCat2 - many [carts] on one template page? (1997)
send mail problem? (1997)
Large database on Mac OS X Server (2000)