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&wagroup1datarq=energy&group4fields=itemname&group4fields=desc&group4fields=ldesc&wngroup4datarq=western&bwzipdatarq=152&max=10]The problem is that the wngroup4datarq seems to be ignored. The results ofthis search return all of the resources in the db where group1fields equalenergy AND zip begins with 152. Unfortunately the search is also returningresources where group4fields contains the word western.(I have the group fields separated out because those fields can contain nonalpha-numeric values)Even a search for just wngroup4datarq fails to find any results (thereshould be thousands for that one):[search db=^envirolink/resources.db&group4fields=itemname&group4fields=desc&group4fields=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 KnauerFounder & CEOGreen Marketplace, Inc.josh@greenmarketplace.com412-420-6400 x300 -phone412-420-6404 -faxAIM: envirolink ICQ#: 9800639Visit http://www.greenmarketplace.com for products that meet the highestsocial 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:
Hello all-I am having a problem with the following search:[search db=resources.db&group1fields=itemname&group1fields=desc&group1fields=ldesc&wagroup1datarq=energy&group4fields=itemname&group4fields=desc&group4fields=ldesc&wngroup4datarq=western&bwzipdatarq=152&max=10]The problem is that the wngroup4datarq seems to be ignored. The results ofthis search return all of the resources in the db where group1fields equalenergy AND zip begins with 152. Unfortunately the search is also returningresources where group4fields contains the word western.(I have the group fields separated out because those fields can contain nonalpha-numeric values)Even a search for just wngroup4datarq fails to find any results (thereshould be thousands for that one):[search db=^envirolink/resources.db&group4fields=itemname&group4fields=desc&group4fields=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 KnauerFounder & CEOGreen Marketplace, Inc.josh@greenmarketplace.com412-420-6400 x300 -phone412-420-6404 -faxAIM: envirolink ICQ#: 9800639Visit http://www.greenmarketplace.com for products that meet the highestsocial 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)