Re: <fieldname>summ=T
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54832
interpreted = N
texte = Humm maybe I'm misunderstanding what you are looking for here.Kind of interesting. Please (if you would) make a list of just exactly what record ID's SHOULD be returned in your current example where ID=7.I will re-read it as you've suggested.Thanks,MKOn Wednesday, December 10, 2003, at 11:08 AM, Donovan Brooke wrote:> 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/>>Signed: Marc Kaiwi-------------------------------------------------------------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:
Humm maybe I'm misunderstanding what you are looking for here.Kind of interesting. Please (if you would) make a list of just exactly what record ID's SHOULD be returned in your current example where ID=7.I will re-read it as you've suggested.Thanks,MKOn Wednesday, December 10, 2003, at 11:08 AM, Donovan Brooke wrote:> 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/>>Signed: Marc Kaiwi-------------------------------------------------------------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/
Marc Kaiwi
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:
WebCat control of Print (2001)
[WriteFile] problems (1997)
More on the email templates (1997)
WCS Newbie question (1997)
[OT] HTML Email in Lotus Notes (2005)
ReturnRaw and redirect (1997)
Problem with CC problem ? (1997)
WCS Newbie question (1997)
Re:no [search] with NT (1997)
Include binary files in template/XML (SOLVED/Request new (2004)
Pithy questions on webcommerce & siteedit (1997)
[WebDNA] Frustrated ... (2019)
Re:E-Mailer (WebCatb15acgiMac) (1997)
Quick poll (2003)
Retrieve deleted files (2001)
Review comparison by PC Magazine: Open for On-line Business (1997)
Ends With (2003)
Hello??? (1997)
Caching [include] files ... (1997)
I'm new be kind (1997)