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

For those of you not on the WebCatalog Beta... (1997) Web Developer Product Awards (1997) Fun with dates (1997) NT or Mac (1997) Ignoring [OrderFile] context (2005) [BULK] [WebDNA] Authorize.net SIM, Server Integration Method (2011) remotely add + sign (1997) Assigning new CART number (1997) [BoldWords] WebCat.acgib15Mac (1997) WebCatalog does not have enough memory message... HELP (2001) Problem (1997) Frames (1997) Cart questions (1997) Search bug. Help (2002) TEXT Variable (2003) Help! WebCat2 bug (1997) frames & carts (1997) listfile options (1997) Webstar 1.3.1 PPC (1997) Change to UPPERCASE (2000)