Re: Search Combining Problem
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57984
interpreted = N
texte = Still having the same problem. If you would like to see the results of thesearch you can view them at this url http://www.mrminocqua.com/mlschainsearchresults-test.htmlHere is the current search code which is still finding the word "Big" in anylake name that contains it as the first word of the Lake Name.[searchdb=^MLSData/mls.db&REMARKS1word=ww&REMARKS1wbrk=,&REMARKS1fbrk=,&wsREMARKS1datarq=LAKE/RIVER: Big,LAKE/RIVER: Mamie,LAKE/RIVER: WestBay&LISTPRICEtype=num&LISTPRICEsort=1&max=15]We are using Webcat 4.51, so I'm not sure if the fbrk option is a validfunction in this version.Jesse----- Original Message ----- From: "Brian Fries"
To: "WebDNA Talk" Sent: Monday, May 24, 2004 1:40 PMSubject: Re: Search Combining Problem> One more... Try adding "&REMARKS1fbrk=," - this will tell WebDNA how to> break the FIELD into words, as opposed to wbrk which tells how to break> the passed-in-value into words.>> - brian>> On May 24, 2004, at 9:55 AM, Jesse Crofoot wrote:>> > 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 having the same problem. If you would like to see the results of thesearch you can view them at this url http://www.mrminocqua.com/mlschainsearchresults-test.htmlHere is the current search code which is still finding the word "Big" in anylake name that contains it as the first word of the Lake Name.[searchdb=^MLSData/mls.db&REMARKS1word=ww&REMARKS1wbrk=,&REMARKS1fbrk=,&wsREMARKS1datarq=LAKE/RIVER: Big,LAKE/RIVER: Mamie,LAKE/RIVER: WestBay&LISTPRICEtype=num&LISTPRICEsort=1&max=15]We are using Webcat 4.51, so I'm not sure if the fbrk option is a validfunction in this version.Jesse----- Original Message ----- From: "Brian Fries" To: "WebDNA Talk" Sent: Monday, May 24, 2004 1:40 PMSubject: Re: Search Combining Problem> One more... Try adding "&REMARKS1fbrk=," - this will tell WebDNA how to> break the FIELD into words, as opposed to wbrk which tells how to break> the passed-in-value into words.>> - brian>> On May 24, 2004, at 9:55 AM, Jesse Crofoot wrote:>> > 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:
Sandboxes (2004)
File Upload (1997)
WebCatalog can't find database (1997)
[isfile] ? (1997)
Uploading out of FMP (2001)
Text data with spaces in them... (1997)
[WebDNA] [OT] DNS Services (2010)
emailer (1997)
[NT] ie 4.0 required (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
WebCatalog NT beta 18 problem (1997)
Cant open pages generated by Webcat (2004)
Share cost of training videos! (1998)
sendmail for email (was Netforms) (1998)
WebCatalog/WebMerchant Manuals Available (1998)
Getting Total Quantity (1997)
WebCat2.0 [format thousands .0f] no go (1997)
same product in cart (1997)
japanese characters (1997)
selecting multiple found items (1997)