group searching problem

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42653
interpreted = N
texte = Hello all-I am having a problem with the following search:[search db=resources.db&group1fields=itemname&group1fields=desc&group1fields=ldesc&w agroup1datarq=energy&group4fields=itemname&group4fields=desc&group4fields=ld esc&wngroup4datarq=western&bwzipdatarq=152&max=10]The problem is that the wngroup4datarq seems to be ignored. The results of this search return all of the resources in the db where group1fields equal energy AND zip begins with 152. Unfortunately the search is also returning resources where group4fields contains the word western.(I have the group fields separated out because those fields can contain non alpha-numeric values)Even a search for just wngroup4datarq fails to find any results (there should be thousands for that one):[search db=^envirolink/resources.db&group4fields=itemname&group4fields=desc&group4fi elds=ldesc&wngroup4datarq=western&max=10] If you want to see this in action, the search starts here:http://www.envirolink.org/advsearch.html?do=advancedsearchAny ideas on why this wouldn't be working?Thanks in advance,Josh Knauer Founder & CEO Green Marketplace, Inc.josh@greenmarketplace.com 412-420-6400 x300 -phone 412-420-6404 -fax AIM: envirolink ICQ#: 9800639Visit http://www.greenmarketplace.com for products that meet the highest social and environmental standards. ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: group searching problem (Stuart Tremain 2002)
  2. Re: group searching problem (Kenneth Grome 2002)
  3. Re: group searching problem (Scott Anderson 2002)
  4. Re: group searching problem (Kenneth Grome 2002)
  5. Re: group searching problem (Josh Knauer 2002)
  6. Re: group searching problem (Donovan 2002)
  7. Re: group searching problem (ROBERT MCPEAK 2002)
  8. Re: group searching problem (Josh Knauer 2002)
  9. Re: group searching problem (Nitai @ ComputerOil 2002)
  10. Re: group searching problem (Josh Knauer 2002)
  11. Re: group searching problem (Kenneth Grome 2002)
  12. Re: group searching problem (Glenn Busbin 2002)
  13. Re: group searching problem (Clayton Randall 2002)
  14. Re: group searching problem (Gary Krockover 2002)
  15. Re: group searching problem (Josh Knauer 2002)
  16. Re: group searching problem (Clayton Randall 2002)
  17. Re: group searching problem (Josh Knauer 2002)
  18. Re: group searching problem (Gary Krockover 2002)
  19. group searching problem (Josh Knauer 2002)
Hello all-I am having a problem with the following search:[search db=resources.db&group1fields=itemname&group1fields=desc&group1fields=ldesc&w agroup1datarq=energy&group4fields=itemname&group4fields=desc&group4fields=ld esc&wngroup4datarq=western&bwzipdatarq=152&max=10]The problem is that the wngroup4datarq seems to be ignored. The results of this search return all of the resources in the db where group1fields equal energy AND zip begins with 152. Unfortunately the search is also returning resources where group4fields contains the word western.(I have the group fields separated out because those fields can contain non alpha-numeric values)Even a search for just wngroup4datarq fails to find any results (there should be thousands for that one):[search db=^envirolink/resources.db&group4fields=itemname&group4fields=desc&group4fi elds=ldesc&wngroup4datarq=western&max=10] If you want to see this in action, the search starts here:http://www.envirolink.org/advsearch.html?do=advancedsearchAny ideas on why this wouldn't be working?Thanks in advance,Josh Knauer Founder & CEO Green Marketplace, Inc.josh@greenmarketplace.com 412-420-6400 x300 -phone 412-420-6404 -fax AIM: envirolink ICQ#: 9800639Visit http://www.greenmarketplace.com for products that meet the highest social and environmental standards. ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Josh Knauer

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:

[WebDNA] Search using CL (2017) 2.0 Info (1997) OS-X/CGI/WebCat (2000) Text data with spaces in them... (1997) [time] math Q (2003) Getting it as [raw] (2004) Menu to select product variations (1997) Still having install problems (2000) (1997) WebCat table size. (2001) Spiders and Bots (2000) 2.0 Info (1997) (1997) HELP WITH DATES (1997) How did *you* learn Web Catalog? (2000) SQL db type (2006) Auto Submit (2000) minimalist shopping cart. (1997) I give up!! (1997) Weird bug, or is there something amiss? (1997)