Search Question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53602
interpreted = N
texte = 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? -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1.206.778.8777 :: jesse@blueboxdev.com ------------------------------------------------------------- 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)
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? -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1.206.778.8777 :: jesse@blueboxdev.com ------------------------------------------------------------- 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/ Jesse Proudman

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 Ad databases? (1997) Can't load tmpl files (1997) [format xs] freeze (1997) Special characters in field names (1998) [WebDNA] Triggers not working (2011) Re:WebCatalog f2 Installation (1997) Trouble with formula.db + more explanation (1997) no global [username] or [password] displayed ... (1997) multi-paragraph fields (1997) passing cart value (2003) PIXO (1997) [WebDNA] Is a '.webdna' suffix better? (2008) [WebDNA] SEARCH question (2011) WebCat2_Mac RETURNs in .db (1997) HTML Editors (1997) WebCat chatroom (1997) RE: too many nested [xxx] (1997) Totals (1999) Just Testing (1997) IPADDRESS mystery (2003)