Re: <fieldname>summ=T

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54827
interpreted = N
texte = Donovan, This got it for me, I added orange, yellow and green and pink z brand tshirts to the database, each was found and nothing else (you'll note that I hard-coded the red zbrand tshirt as the selected product): [text]the_ID=1[/text] [text]ProdID=1[/text]

Product selected is a red brand Z Tshirt

[text]theCATEGORY=[Lookup db=admin/products.db&Value=[the_ID]&lookinfield=ID&returnfield=CATEGORY¬found=][/text]

theCATEGORY=[theCATEGORY]

[text]theBRAND=[Lookup db=admin/products.db&Value=[the_ID]&lookinfield=ID&returnfield=BRAND¬found=][/text]

theBRAND=[theBRAND]

[search db=admin/products.db&neIDdatarq=[the_ID][!] [/!]&neIDdatarqrq=[the_ID][!] [/!]&eqCATEGORYdatarq=[theCATEGORY][!] [/!]&eqBRANDdatarq=[theBRAND][!] [/!]&grNO_INVENTORYdatarq=0[!] [/!]&NO_INVENTORYtype=num[!] [/!]&PRODUCT_IDsort=1[!] [/!]&PRODUCT_IDsdir=ra[!] [/!]&max=4[!] [/!]] Found: [numfound] [founditems] [hideif [index]=4][/hideif] [/founditems] [/search]
[descriptive]  
GK At 10:17 AM 12/10/2003, you wrote: >Donovan Brooke wrote: > >[snip] >>I might have to do some "hard coding of vars" to test so I'll >>post a comparison link if I do. > > >Well, I'm still sort of stumped. > >I've produced a quick test example. > >http://www.euca.us/admin/tests/summ/detail.html > >Notice that the top results still includes the category "socks" as >well as that socks product being a different brand. > >Can anyone suggest a better peramiter structure to attain the >results that I indicate on this test. > >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/ ------------------------------------------------------------- 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)
Donovan, This got it for me, I added orange, yellow and green and pink z brand tshirts to the database, each was found and nothing else (you'll note that I hard-coded the red zbrand tshirt as the selected product): [text]the_ID=1[/text] [text]ProdID=1[/text]

Product selected is a red brand Z Tshirt

[text]theCATEGORY=[Lookup db=admin/products.db&Value=[the_ID]&lookinfield=ID&returnfield=CATEGORY¬found=][/text]

theCATEGORY=[theCATEGORY]

[text]theBRAND=[Lookup db=admin/products.db&Value=[the_ID]&lookinfield=ID&returnfield=BRAND¬found=][/text]

theBRAND=[theBRAND]

[search db=admin/products.db&neIDdatarq=[the_ID][!] [/!]&neIDdatarqrq=[the_ID][!] [/!]&eqCATEGORYdatarq=[theCATEGORY][!] [/!]&eqBRANDdatarq=[theBRAND][!] [/!]&grNO_INVENTORYdatarq=0[!] [/!]&NO_INVENTORYtype=num[!] [/!]&PRODUCT_IDsort=1[!] [/!]&PRODUCT_IDsdir=ra[!] [/!]&max=4[!] [/!]] Found: [numfound] [founditems] [hideif [index]=4][/hideif] [/founditems] [/search]
[descriptive]  
GK At 10:17 AM 12/10/2003, you wrote: >Donovan Brooke wrote: > >[snip] >>I might have to do some "hard coding of vars" to test so I'll >>post a comparison link if I do. > > >Well, I'm still sort of stumped. > >I've produced a quick test example. > >http://www.euca.us/admin/tests/summ/detail.html > >Notice that the top results still includes the category "socks" as >well as that socks product being a different brand. > >Can anyone suggest a better peramiter structure to attain the >results that I indicate on this test. > >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/ ------------------------------------------------------------- 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/ Gary Krockover

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:

Smith Micro supports our users in so many ways... We are here to (1999) Shipping charges based on dollar level (1997) Server Freeze (1998) Searching Multiple DBs (1997) Summing fields (1997) Not really WebCat (1997) WebCatalog can't find database (1997) Web Catalog 2 demo (1997) all records returned. (1997) Google Web Accelerator (2005) Dummy Credit Card Number for debug? (1997) Text data with spaces in them... (1997) Post Test (2008) Using Plug-In while running 1.6.1 (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Re:WebCatalog/WebMerchant III (1998) resorting found set (2005) can WC render sites out? (1997) no global [username] or [password] displayed ... (1997) range searching (1998)