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:
PIXO support (1997)
Orders.db problem (2003)
lineitem variables (1999)
Undeliverable Mail (1997)
Limiting user access to .tmpl files (1997)
autosensing lanague selection (1997)
absolute paths for databases? (1997)
bug in [SendMail] (1997)
Just Testing (1997)
no emailfolder errors? (2000)
WCS Newbie question (1997)
F3 crashing server (1997)
Re:2nd WebCatalog2 Feature Request (1996)
[listfiles] (1998)
Languages (1997)
There's a bug in the math context ... (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Banner Ad Server Solutions Using WEbDNA (2000)
docs for WebCatalog2 (1997)
Shopping carts and reloading pages (1997)