Re: <fieldname>summ=T

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54831
interpreted = N
texte = Marc Kaiwi wrote: > Alright, your search is all messed up, or your database, or both! > > First of all if you "ne" (!=) the [ProdID] in your search then you > return nothing because your database lists all CATEGORY=shoes + BRAND=Z > with the same PRODUCT_ID eliminating them all!!! Actually it doesn't. :-) ProdID is a base product code meaning a T-SHIRT of a particular design that vary's in color and size. It could also mean a Shoe "model" that vary's in size and color. I don't want the currently displayed (PRODID) model to be found, but I do want other products of the same BRAND AND/OR the same CATEGORY to be found. > Second, If you SUMM on PRODUCT_ID (which are all the same in your db) > you only get 1 product listed because they all have the same PRODUCT_ID!!!! > > Have you even read your own code here? What is this a test? I think you need to re-read it ;-) > > The Fix: > 1.) Delete: &nePRODUCT_IDdatarq=[ProdID] > 2.) Delete: &PRODUCT_IDsumm=T > 3.) Add: &IDsumm=T > > Hope this helps! Not really but thanks, Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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: summ=T ( Gary Krockover 2003)
  2. Re: summ=T ( Donovan Brooke 2003)
  3. Re: summ=T ( "WebDna @" 2003)
  4. Re: summ=T ( Gary Krockover 2003)
  5. Re: summ=T ( Marc Kaiwi 2003)
  6. Re: summ=T ( "WebDna @" 2003)
  7. Re: summ=T ( Marc Kaiwi 2003)
  8. Re: summ=T ( Gary Krockover 2003)
  9. Re: summ=T ( Donovan Brooke 2003)
  10. Re: summ=T ( Gary Krockover 2003)
  11. Re: summ=T ( Donovan Brooke 2003)
  12. Re: summ=T ( Tim Robinson 2003)
  13. Re: summ=T ( Gary Krockover 2003)
  14. Re: summ=T ( Donovan Brooke 2003)
  15. Re: summ=T ( Marc Kaiwi 2003)
  16. Re: summ=T ( Gary Krockover 2003)
  17. Re: summ=T ( Marc Kaiwi 2003)
  18. Re: summ=T ( Marc Kaiwi 2003)
  19. Re: summ=T ( Donovan Brooke 2003)
  20. Re: summ=T ( Donovan Brooke 2003)
  21. Re: summ=T ( Donovan Brooke 2003)
  22. Re: summ=T ( Marc Kaiwi 2003)
  23. Re: summ=T ( Gary Krockover 2003)
  24. Re: summ=T ( Marc Kaiwi 2003)
  25. Re: summ=T ( Glenn Busbin 2003)
  26. Re: summ=T ( Donovan Brooke 2003)
  27. Re: summ=T ( Marc Kaiwi 2003)
  28. Re: summ=T ( Donovan Brooke 2003)
  29. Re: summ=T ( Donovan Brooke 2003)
  30. Re: summ=T ( Donovan Brooke 2003)
  31. Re: summ=T ( Andy Mowrey 2003)
  32. Re: summ=T ( Brian Fries 2003)
  33. Re: summ=T ( Donovan Brooke 2003)
  34. summ=T ( Donovan Brooke 2003)
Marc Kaiwi wrote: > Alright, your search is all messed up, or your database, or both! > > First of all if you "ne" (!=) the [ProdID] in your search then you > return nothing because your database lists all CATEGORY=shoes + BRAND=Z > with the same PRODUCT_ID eliminating them all!!! Actually it doesn't. :-) ProdID is a base product code meaning a T-SHIRT of a particular design that vary's in color and size. It could also mean a Shoe "model" that vary's in size and color. I don't want the currently displayed (PRODID) model to be found, but I do want other products of the same BRAND AND/OR the same CATEGORY to be found. > Second, If you SUMM on PRODUCT_ID (which are all the same in your db) > you only get 1 product listed because they all have the same PRODUCT_ID!!!! > > Have you even read your own code here? What is this a test? I think you need to re-read it ;-) > > The Fix: > 1.) Delete: &nePRODUCT_IDdatarq=[ProdID] > 2.) Delete: &PRODUCT_IDsumm=T > 3.) Add: &IDsumm=T > > Hope this helps! Not really but thanks, Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/ Donovan Brooke

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:

Cart Number sequence (1997) accountnum using [listwords] (2001) Hard Questions ? (1997) [protect] is protecting too much!!! (2000) [WebDNA] Version 7.x: webdna.ini and EmailerPrefs (2012) [Reload mydata.db] (1998) Re:trouble (1997) WCS Newbie question (1997) Alais Shopping Cart Directory (1998) Authentication Help (2000) WebCat on Alpha? (1997) Progress !! WAS: Trouble with formula.db (1997) Attaching a plain text file via [sendmail] (2001) Chat Area (2000) WebCat2 beta 11 - new prefs ... (1997) [WebDNA] Weird issue with ADD (2018) Feedback on new features (2000) WebCat2b13MacPlugIn - More limits on [include] (1997) Duplicate Items in the Cart (1998) Explorer 3.0 (1997)