Re: <fieldname>summ=T

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54830
interpreted = N
texte = Gary Krockover wrote: > 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 Hey thanks Gary, This is not going to work, but nothing against your code as it is hard for me to relay all the information about this complex search over email. I want products to be found also in the instance of either of the two (category and brand) matching. There might be another reason why this won't work but that is the main one I think. 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)
Gary Krockover wrote: > 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 Hey thanks Gary, This is not going to work, but nothing against your code as it is hard for me to relay all the information about this complex search over email. I want products to be found also in the instance of either of the two (category and brand) matching. There might be another reason why this won't work but that is the main one I think. 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:

Two options to consider (2008) Include a big block of text (1997) (2004) date pref (1999) Converting characters to numbers ... (1997) WebCatalog vs WebDNA (2002) Max Record length (1997) New Command prefs ... (1997) Loops and [index] (1998) GuestBook example (1997) Version f1 status (1997) Session Number (1998) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) BBEdit grep (2003) For you expert WebDNA coders (was Interesting speed (2003) View order not right (1997) Search: Is this possible? (2005) Adding Message to Order (1997) Country & Ship-to address & other fields ? (1997) NT - Thanks and Taxes (1997)