[WebDNA] Re: group searching not working as expected.

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 106058
interpreted = N
texte = I just checked and the behavior I describe is the same on version 7.. so my question is for the fast cgi too. *Thanks to anyone* who has a suggestion how to do this (see my last question at the bottom) using grouped fields (i.e *without* multiple searches - which I am trying to avoid, because the db is large and going to be very large later.. i.e. SLOW). -G > Hi everyone > > version=6.0 > platform=unix-Linux Intel RedHat > > I hit a wall with group searching which I did not expect. > Can you guys confirm the behavior so I can move on to tackling the > problem another way? (Meanwhile I keep thinking group searching > *should* work the way I want, no?) > > imagine a db like so: > > ==================== START my.db ============================== > feeled1_Fruitfeeled2_WhereGrownfeeled3_HowUsed > 1applewashingtonbaked dessert > 2bananaecuadorbreakfast > 3cherrycaliforniabaked dessert > 4mangoindiaspecial treat > 5pineapplehawaiisweet indian curry > 6blueberrycaliforniabaked dessert > ==================== END my.db ================================ > > We would think that this: > [search > db > = > my > .db > &group1field > = > feeled1_Fruit > &group2field > = > feeled1_Fruit > &eqgroup1data > =1apple&eqgroup2data=3cherry&wsfeeled3_HowUseddatarq=[URL]baked > dessert[/URL]&max=500] > > ...should return the 1st and 3rd record, correct? > > But it returns the 1st, 3rd, and 6th records. > > If you were coding this, how would you write this search so that it > finds ONLY record #1 & #3, using grouped fields? > > (I need to be able to tell the search to return records where: > -[feeled3_HowUsed] = baked dessert, *AND* > -[feeled1_Fruit] = (*either* "1apple" or "3cherry" or "4mango" > > ...which is only records #1 and #3.) > > ------------ > Govinda > > > > > > ------------ Govinda Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] group searching not working as expected. (Govinda 2010)
  2. Re: [WebDNA] group searching not working as expected. (Terry Wilson 2010)
  3. Re: [WebDNA] group searching not working as expected. (Govinda 2010)
  4. Re: [WebDNA] group searching not working as expected. ("Terry Wilson" 2010)
  5. Re: [WebDNA] group searching not working as expected. (Govinda 2010)
  6. Re: [WebDNA] group searching not working as expected. (Kenneth Grome 2010)
  7. Re: [WebDNA] group searching not working as expected. (Govinda 2010)
  8. Re: [WebDNA] group searching not working as expected. (frank@cwolfe.com 2010)
  9. [WebDNA] group searching not working as expected. (Govinda 2010)
I just checked and the behavior I describe is the same on version 7.. so my question is for the fast cgi too. *Thanks to anyone* who has a suggestion how to do this (see my last question at the bottom) using grouped fields (i.e *without* multiple searches - which I am trying to avoid, because the db is large and going to be very large later.. i.e. SLOW). -G > Hi everyone > > version=6.0 > platform=unix-Linux Intel RedHat > > I hit a wall with group searching which I did not expect. > Can you guys confirm the behavior so I can move on to tackling the > problem another way? (Meanwhile I keep thinking group searching > *should* work the way I want, no?) > > imagine a db like so: > > ==================== START my.db ============================== > feeled1_Fruitfeeled2_WhereGrownfeeled3_HowUsed > 1applewashingtonbaked dessert > 2bananaecuadorbreakfast > 3cherrycaliforniabaked dessert > 4mangoindiaspecial treat > 5pineapplehawaiisweet indian curry > 6blueberrycaliforniabaked dessert > ==================== END my.db ================================ > > We would think that this: > [search > db > = > my > .db > &group1field > = > feeled1_Fruit > &group2field > = > feeled1_Fruit > &eqgroup1data > =1apple&eqgroup2data=3cherry&wsfeeled3_HowUseddatarq=[url]baked > dessert[/URL]&max=500] > > ...should return the 1st and 3rd record, correct? > > But it returns the 1st, 3rd, and 6th records. > > If you were coding this, how would you write this search so that it > finds ONLY record #1 & #3, using grouped fields? > > (I need to be able to tell the search to return records where: > -[feeled3_HowUsed] = baked dessert, *AND* > -[feeled1_Fruit] = (*either* "1apple" or "3cherry" or "4mango" > > ...which is only records #1 and #3.) > > ------------ > Govinda > > > > > > ------------ Govinda Govinda

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:

Erotic Sites (1997) RE:It just Does't add up!!! (1997) OT Cookie limit (2001) Using Plug-In while running 1.6.1 (1997) [WebDNA] Installation problems for IIS 6 (2010) Frames and [cart] (1998) orderfile headers (was: 2nd Request for help/adviceonvariable pricing) (2000) Instructions for Digest (1997) WebCatalog Beta Documentation (1997) Sort Order on a page search (1997) searches with dash, period etc. (2000) SKU lookup (1997) Cancel Subscription (1996) Getting Emailer to send mail (1997) How do I send a 404 HTTP header ? (2004) Calendar Solutions (1998) Frames and WebCat (1997) Help-.html extention and Serial Number not working. (2000) [WebDNA] Acceleratin Search / Index Performance in a Formum Service (2013) Almost a there but..bye bye NetCloak (1997)