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.frankOn 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_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&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:
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.frankOn 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)