Re: group searching problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42657
interpreted = N
texte = Clayton-The following code still does not yield any results (when I know there are thousands):[search db=^envirolink/resources.db&group4fields=itemname&group4fields=desc&group4fi elds=ldesc&wngroup4datarq=western&max=10]This is just the group4 fields. It also does not matter whether I use wngroup4datarq or negroup4datarq.Is there something obvious I am overlooking or could this be a bug?-josh On 8/18/02 3:23 PM, Clayton Randall
wrote:> try using just the group4 fields first, does that work? If so, then > add back in the other criteria, and see if they are broken now > > >> Yes, I did. Same results. The group4data query is being ignored, it seems. >> >> -josh >> >> >> On 8/18/02 3:12 PM, Gary Krockover wrote: >> >>> Did you try: >>> >>> negroup4datarq=western >>> >>> ? >>> >>> GK >>> >>> >>>> 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=advancedsearch >>>> >>>> Any 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#: 9800639 >>>> >>>> Visit 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/ >>> >>> >>> ------------------------------------------------------------- >>> 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 >> Founder & CEO >> Green Marketplace, Inc. >> >> josh@greenmarketplace.com >> 412-420-6400 x300 -phone >> 412-420-6404 -fax >> AIM: envirolink ICQ#: 9800639 >> >> Visit 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/ > > > ------------------------------------------------------------- > 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 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:
Clayton-The following code still does not yield any results (when I know there are thousands):[search db=^envirolink/resources.db&group4fields=itemname&group4fields=desc&group4fi elds=ldesc&wngroup4datarq=western&max=10]This is just the group4 fields. It also does not matter whether I use wngroup4datarq or negroup4datarq.Is there something obvious I am overlooking or could this be a bug?-josh On 8/18/02 3:23 PM, Clayton Randall wrote:> try using just the group4 fields first, does that work? If so, then > add back in the other criteria, and see if they are broken now > > >> Yes, I did. Same results. The group4data query is being ignored, it seems. >> >> -josh >> >> >> On 8/18/02 3:12 PM, Gary Krockover wrote: >> >>> Did you try: >>> >>> negroup4datarq=western >>> >>> ? >>> >>> GK >>> >>> >>>> 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=advancedsearch >>>> >>>> Any 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#: 9800639 >>>> >>>> Visit 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/ >>> >>> >>> ------------------------------------------------------------- >>> 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 >> Founder & CEO >> Green Marketplace, Inc. >> >> josh@greenmarketplace.com >> 412-420-6400 x300 -phone >> 412-420-6404 -fax >> AIM: envirolink ICQ#: 9800639 >> >> Visit 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/ > > > ------------------------------------------------------------- > 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 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:
SMSI, please fix the StandardConversions.db (2005)
BBEdit/HTMLcomments/WebCat/[/FONT] (1999)
RE: Last desperate attempt (1998)
Re requiredFields parameter (1998)
Cookies? (1997)
Emailer update for Mac? (1998)
getchars broken? (1997)
How can I record purchases to a database? (1998)
Conversion Database Blues (2001)
assigning a id no. (2000)
Email notification to one of multiple vendors ? (1997)
WebCatalog Hosting (1996)
Sorry WebDNA server not running (2002)
docs for WebCatalog2 (1997)
Emailer tracking (1997)
WebCat2 - storing unformatted date data? (1997)
TCP/IP connect (1998)
Bad Install... (2003)
include (1998)
I've been thinking (2002)