Re: group searching problem

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42659
interpreted = N
texte = Josh, your syntax for building the groups is wrong. It should be group1field=FirstName+LastName+Address&wogroup1data=Lanetry using that format and try again.>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#: 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/ 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)
Josh, your syntax for building the groups is wrong. It should be group1field=FirstName+LastName+Address&wogroup1data=Lanetry using that format and try again.>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#: 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/ Clayton Randall

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:

Dual 2GHz G5 (2003) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Two submit buttons ? (1997) Using [showif] within [lineitems] (2000) WebCat2 - Getting to the browser's username/password data (1997) date tag not interpreted (2000) PIXO with cometsite ... and/or other plugins (1998) japanese characters (1997) [WAY OFF TOPIC] anybody live in Kansas? (2003) Setting up shop (1997) Nesting Search Within Tag? (1997) Email truncation in Eudora. (1998) Speeding up my [showif] performance (1999) How To question on setting up downloads (1997) taxRate and grandTotal calculation is not showing up on my (2000) ReturnRaw and redirect (1997) Database Helper missing? (2000) [WebDNA] List Files question (2009) Robert Minor duplicate mail (1997) Country & Ship-to address & other fields ? (1997)