[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_Fruit
feeled2_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:
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)