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:

Multiple catalog databases and showcart (1997) Username/Password with [Protect] (2000) Sendmail - Attachment / My First Post (2001) what servers are supported for Typhoon? (1997) Stats (2004) Invisible file issue now a real 'bug' (1999) WebCat Error Log problem (2.0.1, acgi, Mac) (1997) Date Formats (1997) WebDelivery downloads alias, not original ? (1997) IE Cache Problems... (1999) WebCat2b13MacPlugIn - [include] (1997) WebCat virtual postcard is done! Thanks for the help! (1998) Problem getting shipping to calculate (2003) delete fails (2000) Running _every_ page through WebCat ? (1997) Counting files (1998) Printing controls - form feeds (2002) need to add a sku field to an existing db (2005) Upload files (2004) Keep away (1997)