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:

    
  1. Re: [WebDNA] Search question (frank@cwolfe.com 2013)
  2. Re: [WebDNA] Search question ("Terry Wilson" 2013)
  3. RE: [WebDNA] Search question ("Terry Nair" 2013)
  4. Re: [WebDNA] Search question (Lawrence Banahan 2013)
  5. [WebDNA] Search question (frank@cwolfe.com 2013)
  6. Re: [WebDNA] Search question (Steve Craig 2012)
  7. Re: [WebDNA] Search question (Toby Cox 2012)
  8. Re: [WebDNA] Search question (Steve Craig 2012)
  9. Re: [WebDNA] Search question (Steve Craig 2012)
  10. Re: [WebDNA] Search question (Toby Cox 2012)
  11. [WebDNA] Search question (Steve Craig 2012)
  12. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  13. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  14. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  15. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Kenneth Grome 2011)
  16. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  17. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  18. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  19. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  20. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  21. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  22. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  23. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  24. Re: [WebDNA] SEARCH question (Kenneth Grome 2011)
  25. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  26. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  27. Re: [WebDNA] SEARCH question (Govinda 2011)
  28. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  29. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  30. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  31. Re: [WebDNA] SEARCH question (Steve Raslevich 2011)
  32. [WebDNA] SEARCH question (Stuart Tremain 2011)
  33. Re: [WebDNA] Search Question (Tony Miller 2009)
  34. Re: [WebDNA] Search Question (John Butler 2009)
  35. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  36. Re: [WebDNA] Search Question (Tony Miller 2009)
  37. Re: [WebDNA] Search Question ( 2009)
  38. Re: [WebDNA] Search Question (Tony Miller 2009)
  39. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  40. Re: [WebDNA] Search Question ( 2009)
  41. [WebDNA] Search Question (Tony Miller 2009)
  42. Search question with a lookup (3 dbs) ( Palle Bo Nielsen 2004)
  43. Re: Another Search Question ( Donovan Brooke 2003)
  44. Re: Another Search Question ( Gary Krockover 2003)
  45. Re: Another Search Question ( Donovan Brooke 2003)
  46. Re: Another Search Question ( Tim Robinson 2003)
  47. Another Search Question ( Donovan Brooke 2003)
  48. Re: Search Question ( "Alain Russell" 2003)
  49. Search Question ( Jesse Proudman 2003)
  50. Re: Search Question ( Jesse Proudman 2003)
  51. Re: Search Question ( "Dan Strong" 2003)
  52. Re: Search Question ( Mark Derrick 2003)
  53. Search Question ( Jesse Proudman 2003)
  54. Re: Search Question ( 2003)
  55. Re: Search Question ( Daryl Mitchell 2003)
  56. Re: Search Question ( 2003)
  57. Re: Search Question ( Daryl Mitchell 2003)
  58. Search Question ( 2003)
  59. Re: Search Question (Matthew A Perosi 2003)
  60. Re: Search Question (Kimberly D. Walls 2003)
  61. Re: search question (Dale Therio 2001)
  62. Re: search question (Dale Therio 2001)
  63. Re: search question (Vincent Medina 2001)
  64. Re: search question (Dale Therio 2001)
  65. Re: search question (Christer Olsson 2001)
  66. Re: search question (Rob Marquardt 2001)
  67. Re: search question (Dale Therio 2001)
  68. Re: search question (Anup Setty 2001)
  69. Re: search question (Vincent Medina 2001)
  70. Re: search question (Dale Therio 2001)
  71. Re: search question (Anup Setty 2001)
  72. Re: search question (John Peacock 2001)
  73. Re: search question (Dale Therio 2001)
  74. Re: search question (Jimmi Kristensen 2001)
  75. Re: Newbie search question (between two dates) (Kenneth Grome 2001)
  76. Re: Newbie search question (between two dates) (Clint Davis 2001)
  77. Re: Newbie search question (between two dates) (Matthew Bohne 2001)
  78. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  79. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  80. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  81. Re: Newbie search question (between two dates) (Brian Fries 2001)
  82. Re: Newbie search question (between two dates) (Brian Fries 2001)
  83. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  84. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  85. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  86. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  87. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  88. Newbie search question (between two dates) (Matthew Bohne 2001)
  89. Re: Search Question (John Butler 2000)
  90. Re: Search Question (Mark Derrick 2000)
  91. Re: Search Question (John Butler 2000)
  92. Re: Search Question (Alex Cheparev 2000)
  93. Re: Search Question (Mark Derrick 2000)
  94. Re: Search Question (Kim Ingram 2000)
  95. Re: Search Question (Paul Fowler 2000)
  96. Re: Search Question (Kim Ingram 2000)
  97. Re: Search Question (Nathaniel Hadley 2000)
  98. Re: Search Question (Jason Tyler 2000)
  99. Re: Search Questions (Brady J. Horenstein 2000)
  100. Re: Search Questions (PCS Technical Support 2000)
  101. Re: Search Questions (Bob Minor 2000)
  102. Re: Search Questions (Kenneth Grome 2000)
  103. Re: Search Questions (Paul Fowler 2000)
  104. Re: Search question (Kenneth Grome 1999)
  105. Re: Newbie - Search question (Julian Clayton 1998)
  106. Re: Newbie - Search question (Mícheál O Sé 1998)
  107. Newbie - Search question (Nitai 1998)
  108. Re: Another search question please... (PCS Technical Support 1998)
  109. Another search question please... (Scott Szretter 1998)
  110. Re: Forms Search Questions (Grant Hulbert 1997)
  111. Re: Forms Search Questions (Kenneth Grome 1997)
  112. Re: Forms Search Questions (Jacques VERNAY 1997)
  113. Re: Forms Search Questions (Christer Olsson 1997)
  114. Re: Forms Search Questions (Christer Olsson 1997)
  115. Re: Forms Search Questions (Kenneth Grome 1997)
  116. Forms Search Questions (Richard Shapiro 1997)
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)