[WebDNA] group searching not working as expected.
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 106055
interpreted = N
texte = Hi everyoneversion=6.0platform=unix-Linux Intel RedHatI 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_HowUsed1applewashingtonbaked dessert2bananaecuadorbreakfast3cherrycaliforniabaked dessert4mangoindiaspecial treat5pineapplehawaiisweet indian curry6blueberrycaliforniabaked 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
Associated Messages, from the most recent to the oldest:
Hi everyoneversion=6.0platform=unix-Linux Intel RedHatI 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_HowUsed1applewashingtonbaked dessert2bananaecuadorbreakfast3cherrycaliforniabaked dessert4mangoindiaspecial treat5pineapplehawaiisweet indian curry6blueberrycaliforniabaked 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
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:
convert characters (2003)
Document Contains No Data! (1997)
WebCat2 several catalogs? (1997)
Search Debugging (2004)
[WebDNA] Poll: Discussion Forum (2009)
Emailer and encryption (1997)
Aaron kant add (or whatever it was) (2000)
Help! WebCat2 bug (1997)
[sendmail] questions... (1997)
What am I doing wrong? --GOT IT! (2000)
Sendmail & Time Issue (2001)
EmailCompleted Clean Up (2001)
RE: WebCatalog2 for NT Beta Request (1997)
Displaying xx number of characters (1997)
unable to launch acgi in WebCat (1997)
This list needs a digest: rant, rave... (1997)
Error Lob.db records error message not name (1997)
timing out? (1997)
Template Security error (1997)
Problems appending to database (1997)