Re: Search Combining Problem
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57982
interpreted = N
texte = Still picking up anything with the word "Big" in the REMAKS1 field. I have simplified the search by dropping the 1st search that determines the lakes in a given lake chain and have writen direct search code for one of the chains. Below is the search, any other ideas or suggestions will be greatly appreciated. [search db=^MLSData/mls.db&REMARKS1word=ww&REMARKS1wbrk=,&wsREMARKS1datarq=Big,Mamie ,West Bay&LISTPRICEtype=num&LISTPRICEsort=1&max=15] ----- Original Message ----- From: "Brian Fries"
To: "WebDNA Talk" Sent: Monday, May 24, 2004 10:59 AM Subject: Re: Search Combining Problem > Try adding "&REMARKS1word=ww" so it will only match "whole words". > > - brian > > On May 24, 2004, at 8:12 AM, Jesse Crofoot wrote: > > > Looks like that did the trick for the most part, however I'm still > > having > > problems with the search. The problem I'm running into now is one of > > the > > lakes is simply named "Big" and there are a few lakes with "Big" in > > the name > > so those are being found by the search as well. Any other suggestions > > on > > how to hammer down the search. Below is my full search code. > > > > [search > > db=^MLSData/ > > lakechains.db&eqLAKECHAIN_CHAINdatarq=[LAKECHAIN]&LAKECHAIN_LAKE > > sort=1] > > > > [search > > db=^MLSData/ > > mls.db&REMARKS1wbrk=,&woREMARKS1datarq=[founditems][LAKECHAIN_LA > > KE][hideif > > [INDEX]=[NUMFOUND]],[/hideif][/ > > founditems]&LISTPRICEtype=num&LISTPRICEsort=1 > > &max=15] > > > > > > ----- Original Message ----- > > From: "Erol Guneri" > > To: "WebDNA Talk" > > Sent: Monday, May 24, 2004 8:39 AM > > Subject: Re: Search Combining Problem > > > > > >> Hi Jesse, > >> > >> I think you need to add &REMARKS1wbrk=, to your search string so that > >> it > >> knows what the seperator is, making your search string: > >> > >> [search db=^MLSData/mls.db&wsREMARKS1data=[url]LAKE/RIVER: Little > >> Tomahawk,LAKE/RIVER:Minocqua[/url] > >> &REMARKS1wbrk=,&LISTPRICEtype=num&LISTPRICEsort=1&max=15] > >> > >> Erol > >> > >> > >> ----- Original Message ----- > >> From: "Jesse Crofoot" > >> To: "WebDNA Talk" > >> Sent: Monday, May 24, 2004 2:24 PM > >> Subject: Search Combining Problem > >> > >> > >>> Hello all, > >>> > >>> I'm having a problem with a combined search. I've read over the > >> information > >>> in the guide however, the search is not doing what I'm attempting to > >>> do. > >>> What I'm trying to accomplish is a search in a field called Remarks1 > >>> for > >>> several different lake names. below is the search code I'm working > > with. > >>> This is my test code not the final search as it will be generated by > >>> a > >>> database search to determine the lakes belonging in a given lake > >>> chain. > >>> Here is my test search code. > >>> > >>> [search db=^MLSData/mls.db&wsREMARKS1data=[url]LAKE/RIVER: Little > >>> Tomahawk,LAKE/RIVER: > >>> Minocqua[/url]&LISTPRICEtype=num&LISTPRICEsort=1&max=15] > >>> > >>> If I remove the 2nd item LAKE/RIVER: Minocqua, the search works > >>> properly > >>> returning only the properties listed that are on Little Tomahawk. > > However > >>> with the 2nd item in the search I'm getting 0 found. Any > >>> suggestions on > >>> this will be greatly appreciated. > >>> > >>> Jesse L Crofoot > >>> Web Designer > >>> By Request Web Designs > >>> & HodagSports.Com > >>> jesse@hodagsports.com > > > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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://webdna.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Still picking up anything with the word "Big" in the REMAKS1 field. I have simplified the search by dropping the 1st search that determines the lakes in a given lake chain and have writen direct search code for one of the chains. Below is the search, any other ideas or suggestions will be greatly appreciated. [search db=^MLSData/mls.db&REMARKS1word=ww&REMARKS1wbrk=,&wsREMARKS1datarq=Big,Mamie ,West Bay&LISTPRICEtype=num&LISTPRICEsort=1&max=15] ----- Original Message ----- From: "Brian Fries" To: "WebDNA Talk" Sent: Monday, May 24, 2004 10:59 AM Subject: Re: Search Combining Problem > Try adding "&REMARKS1word=ww" so it will only match "whole words". > > - brian > > On May 24, 2004, at 8:12 AM, Jesse Crofoot wrote: > > > Looks like that did the trick for the most part, however I'm still > > having > > problems with the search. The problem I'm running into now is one of > > the > > lakes is simply named "Big" and there are a few lakes with "Big" in > > the name > > so those are being found by the search as well. Any other suggestions > > on > > how to hammer down the search. Below is my full search code. > > > > [search > > db=^MLSData/ > > lakechains.db&eqLAKECHAIN_CHAINdatarq=[LAKECHAIN]&LAKECHAIN_LAKE > > sort=1] > > > > [search > > db=^MLSData/ > > mls.db&REMARKS1wbrk=,&woREMARKS1datarq=[founditems][LAKECHAIN_LA > > KE][hideif > > [INDEX]=[NUMFOUND]],[/hideif][/ > > founditems]&LISTPRICEtype=num&LISTPRICEsort=1 > > &max=15] > > > > > > ----- Original Message ----- > > From: "Erol Guneri" > > To: "WebDNA Talk" > > Sent: Monday, May 24, 2004 8:39 AM > > Subject: Re: Search Combining Problem > > > > > >> Hi Jesse, > >> > >> I think you need to add &REMARKS1wbrk=, to your search string so that > >> it > >> knows what the seperator is, making your search string: > >> > >> [search db=^MLSData/mls.db&wsREMARKS1data=[url]LAKE/RIVER: Little > >> Tomahawk,LAKE/RIVER:Minocqua[/url] > >> &REMARKS1wbrk=,&LISTPRICEtype=num&LISTPRICEsort=1&max=15] > >> > >> Erol > >> > >> > >> ----- Original Message ----- > >> From: "Jesse Crofoot" > >> To: "WebDNA Talk" > >> Sent: Monday, May 24, 2004 2:24 PM > >> Subject: Search Combining Problem > >> > >> > >>> Hello all, > >>> > >>> I'm having a problem with a combined search. I've read over the > >> information > >>> in the guide however, the search is not doing what I'm attempting to > >>> do. > >>> What I'm trying to accomplish is a search in a field called Remarks1 > >>> for > >>> several different lake names. below is the search code I'm working > > with. > >>> This is my test code not the final search as it will be generated by > >>> a > >>> database search to determine the lakes belonging in a given lake > >>> chain. > >>> Here is my test search code. > >>> > >>> [search db=^MLSData/mls.db&wsREMARKS1data=[url]LAKE/RIVER: Little > >>> Tomahawk,LAKE/RIVER: > >>> Minocqua[/url]&LISTPRICEtype=num&LISTPRICEsort=1&max=15] > >>> > >>> If I remove the 2nd item LAKE/RIVER: Minocqua, the search works > >>> properly > >>> returning only the properties listed that are on Little Tomahawk. > > However > >>> with the 2nd item in the search I'm getting 0 found. Any > >>> suggestions on > >>> this will be greatly appreciated. > >>> > >>> Jesse L Crofoot > >>> Web Designer > >>> By Request Web Designs > >>> & HodagSports.Com > >>> jesse@hodagsports.com > > > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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://webdna.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://webdna.smithmicro.com/
"Jesse Crofoot"
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:
Job Opening (2003)
Can someone look at this (2003)
Active Server Code... (1998)
Fwd: Problems with Webcatalog Plug-in (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
Less than or equal to........ (1997)
input type=file has no value? (2003)
sort without the or a (1998)
Reversed words (1997)
email (1998)
[WebDNA] Webstar (2008)
[WebDNA] Brian Harrington (2019)
Summ=T Problem (1997)
Using [showif] (2000)
WebCat 3.04-3.07 plug-in dying on server.... (2000)
More than one db with the same namn (was: WC2f3) (1997)
Search in 2 or more catalogs (1997)
Removing [showif] makes a big difference in speed (1997)
Loss in form (1998)
Mac: LModelDirector bug fix (1997)