Re: group searching problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42658
interpreted = N
texte = You're searching the same grouped fields twice, try it just once:[search db=resources.db&group1fields=itemname+desc+ldesc&[!][/!]wagroup1datarq=energy&negroup1datarq=western&bwzipdatarq=152&max=10]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 resultsof> this search return all of the resources in the db where group1fields equal> energy AND zip begins with 152. Unfortunately the search is alsoreturning> resources where group4fields contains the word western.>> (I have the group fields separated out because those fields can containnon> 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/
Associated Messages, from the most recent to the oldest:
You're searching the same grouped fields twice, try it just once:[search db=resources.db&group1fields=itemname+desc+ldesc&[!][/!]wagroup1datarq=energy&negroup1datarq=western&bwzipdatarq=152&max=10]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 resultsof> this search return all of the resources in the db where group1fields equal> energy AND zip begins with 152. Unfortunately the search is alsoreturning> resources where group4fields contains the word western.>> (I have the group fields separated out because those fields can containnon> 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/
Gary Krockover
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:
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[append] and SSL (1997)
HELP WITH DATES (1997)
WebCat vs. ASP (1999)
OT - New Ti Books (2002)
real beginner stumped (2000)
Trouble with formula.db (1997)
Showif, Hideif reverse logic ? (1997)
server side includes & webcatalog (2000)
[TIME] format. (2004)
WC2b15 File Corruption (1997)
missing records (1998)
Generating Report Totals (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
RE: PDF (1999)
Problems searching from a FORM (1997)
time + (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Which GUI HTML editors work with WC ? (1997)
Multiple postings (2000)