Re: Help with Search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57843
interpreted = N
texte = Please disregard, was an RTFM question and I found the answer :)----- Original Message ----- From: "Jesse Crofoot"
To: "WebDNA Talk" Sent: Friday, May 14, 2004 11:51 AMSubject: Help with Search> First off, what I'm trying to accomplish is to search the field in the> database REMARKS1 for any of several different values. The search I'm> currently using is shown below.> First I search the lakechains db to determine what lakes are part of that> chain>> [search>db=^MLSData/lakechains.db&geLAKECHAIN_ID=0&eqLAKECHAIN_CHAINdatarq=[LAKECHAI> N]&LAKECHAIN_LAKEsort=1]>> Then I add those into a search to display the properties that are on those> lakes.>> [search>db=^MLSData/mls.db[founditems]&eqREMARKS1data=[LAKECHAIN_LAKE][/founditems]&> LISTPRICEtype=num&LISTPRICEsort=1&max=15]> [numfound] Properties Match Your Search
> [founditems]>> Below is the [searchstring] that is being processed and I'm getting 0> results even though I know there are properties on those lakes.>>?command=search&db=%5EMLSData/mls.db&eqREMARKS1data=Catfish&eqREMARKS1data=C>ranberry&eqREMARKS1data=Duck&eqREMARKS1data=Eagle&eqREMARKS1data=Lynx&eqREMA>RKS1data=Otter&eqREMARKS1data=Scattering%20Rice&eqREMARKS1data=Voyageur&eqRE>MARKS1data=Watersmeet&eqREMARKS1data=Yellow%20Birch&LISTPRICEtype=num&LISTPR> ICEsort=1&max=15&startAt=16>> Any suggestions would be greatly appreciated.>> Jesse L Crofoot> Web Designer> By Request Web Designs> & HodagSports.Com> jesse@hodagsports.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:
Please disregard, was an RTFM question and I found the answer :)----- Original Message ----- From: "Jesse Crofoot" To: "WebDNA Talk" Sent: Friday, May 14, 2004 11:51 AMSubject: Help with Search> First off, what I'm trying to accomplish is to search the field in the> database REMARKS1 for any of several different values. The search I'm> currently using is shown below.> First I search the lakechains db to determine what lakes are part of that> chain>> [search>db=^MLSData/lakechains.db&geLAKECHAIN_ID=0&eqLAKECHAIN_CHAINdatarq=[LAKECHAI> N]&LAKECHAIN_LAKEsort=1]>> Then I add those into a search to display the properties that are on those> lakes.>> [search>db=^MLSData/mls.db[founditems]&eqREMARKS1data=[LAKECHAIN_LAKE][/founditems]&> LISTPRICEtype=num&LISTPRICEsort=1&max=15]> [numfound] Properties Match Your Search
> [founditems]>> Below is the [searchstring] that is being processed and I'm getting 0> results even though I know there are properties on those lakes.>>?command=search&db=%5EMLSData/mls.db&eqREMARKS1data=Catfish&eqREMARKS1data=C>ranberry&eqREMARKS1data=Duck&eqREMARKS1data=Eagle&eqREMARKS1data=Lynx&eqREMA>RKS1data=Otter&eqREMARKS1data=Scattering%20Rice&eqREMARKS1data=Voyageur&eqRE>MARKS1data=Watersmeet&eqREMARKS1data=Yellow%20Birch&LISTPRICEtype=num&LISTPR> ICEsort=1&max=15&startAt=16>> Any suggestions would be greatly appreciated.>> Jesse L Crofoot> Web Designer> By Request Web Designs> & HodagSports.Com> jesse@hodagsports.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:
Unix DB Permission Error (2002)
WebDNA update from Smith Micro (2002)
Re2: frames & carts (1997)
pass a captured value (2004)
politeness (was searches with dash...) Please Read (2000)
Purchased cart being overwritten - still !?? (1997)
My new discussion forum (2003)
too many nested [xxx] (1997)
Shared conversion under WebTen (1998)
webmerch and serials - almost there (1997)
Cookies (1999)
# of real domains on 1 web server (1997)
Moving Webcatalog folder? (2001)
Sandboxes & Kitty Litter trays (2003)
Bug Report, maybe (1997)
Credit Card Number checking (1997)
Not really WebCat- (1997)
Search in 2 or more catalogs (1997)
How to Sort Summ data ? (1997)
GuestBook example (1997)