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

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 106056
interpreted = N
texte = That happens to me all the time. I have to make sure that Owner, Group, and You, can all read and write. I use the Apple Get info dialog for each DB. Be sure to close the database [closedatabase] before checking your changes because if the DB is in memory it does not seem to recognize the permission changes. frank On Dec 28, 2010, at 2:15 PM, Govinda wrote: > 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&eqgroup1d > ata=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 > > > > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us > > 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)
That happens to me all the time. I have to make sure that Owner, Group, and You, can all read and write. I use the Apple Get info dialog for each DB. Be sure to close the database [closedatabase] before checking your changes because if the DB is in memory it does not seem to recognize the permission changes. frank On Dec 28, 2010, at 2:15 PM, Govinda wrote: > 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&eqgroup1d > ata=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 > > > > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us > > frank@cwolfe.com

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:

SV: Mass Mail (2000) [include] error message (was:how to put/keep product customization info in basket?) (1998) permission deny help please (2004) Building Calendars (1997) Problem displaying search result (1997) ACGI processing for .html (1997) Error Log.db --however (1997) Shipping rate x Quantity solution needed (2000) php vs WebCatalog (2000) BGcolor (1997) includes and cart numbers (1997) ftp to webstar (2001) MATH TIME (1997) More on the email templates (1997) NT - Thanks and Taxes (1997) 2.01 upgrade problems (1997) Multiple Users.db Possible? (1997) emailer on Windows Beta 18 (1997) Alternating colors (1997) Display [price] in banner ad (1998)