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 ofa particular design that vary's in color and size. It could also meana Shoe "model" that vary's in size and color.I don't want the currently displayed (PRODID) model to be found, but I do wantother 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:
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 ofa particular design that vary's in color and size. It could also meana Shoe "model" that vary's in size and color.I don't want the currently displayed (PRODID) model to be found, but I do wantother 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)