[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:

bug in [SendMail] (1997) authenticate and password (1998) Writing to PDF (2003) Trying to loop for letters (1999) Problems with [Applescript] (1997) textA and Title? (1997) PSC recommends what date format yr 2000??? (1997) Size issues (2001) Practice runs ? (1997) WebCatalog.acgi quitting with error Type 2 (1998) Include a big block of text (1997) WC2b15 File Corruption (1997) Limit to Field Length in DB (1998) Pithy questions on webcommerce & siteedit (1997) The beginning (1997) Adding Header Values with [SetHeader] (1998) RE: SSL and WebCatalog (1997) WebCat2b12--[searchstring] bug (1997) WCS Newbie question (1997) credit card - Revised (1997)