Help with Search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57842
interpreted = N
texte = First off, what I'm trying to accomplish is to search the field in thedatabase REMARKS1 for any of several different values. The search I'mcurrently using is shown below.First I search the lakechains db to determine what lakes are part of thatchain[searchdb=^MLSData/lakechains.db&geLAKECHAIN_ID=0&eqLAKECHAIN_CHAINdatarq=[LAKECHAIN]&LAKECHAIN_LAKEsort=1]Then I add those into a search to display the properties that are on thoselakes.[searchdb=^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 0results even though I know there are properties on those lakes.?command=search&db=%5EMLSData/mls.db&eqREMARKS1data=Catfish&eqREMARKS1data=Cranberry&eqREMARKS1data=Duck&eqREMARKS1data=Eagle&eqREMARKS1data=Lynx&eqREMARKS1data=Otter&eqREMARKS1data=Scattering%20Rice&eqREMARKS1data=Voyageur&eqREMARKS1data=Watersmeet&eqREMARKS1data=Yellow%20Birch&LISTPRICEtype=num&LISTPRICEsort=1&max=15&startAt=16Any suggestions would be greatly appreciated.Jesse L CrofootWeb DesignerBy Request Web Designs & HodagSports.Comjesse@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/
Associated Messages, from the most recent to the oldest:
First off, what I'm trying to accomplish is to search the field in thedatabase REMARKS1 for any of several different values. The search I'mcurrently using is shown below.First I search the lakechains db to determine what lakes are part of thatchain[searchdb=^MLSData/lakechains.db&geLAKECHAIN_ID=0&eqLAKECHAIN_CHAINdatarq=[LAKECHAIN]&LAKECHAIN_LAKEsort=1]Then I add those into a search to display the properties that are on thoselakes.[searchdb=^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 0results even though I know there are properties on those lakes.?command=search&db=%5EMLSData/mls.db&eqREMARKS1data=Catfish&eqREMARKS1data=Cranberry&eqREMARKS1data=Duck&eqREMARKS1data=Eagle&eqREMARKS1data=Lynx&eqREMARKS1data=Otter&eqREMARKS1data=Scattering%20Rice&eqREMARKS1data=Voyageur&eqREMARKS1data=Watersmeet&eqREMARKS1data=Yellow%20Birch&LISTPRICEtype=num&LISTPRICEsort=1&max=15&startAt=16Any suggestions would be greatly appreciated.Jesse L CrofootWeb DesignerBy Request Web Designs & HodagSports.Comjesse@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/
"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:
Draft Manual, Tutorial, and more (1997)
WebCat2: multiple currency support (1997)
FM and Webcat together? (1998)
WebCat b13 CGI -shownext- (1997)
Sort Order on a page search (1997)
[WebDNA] encoding with webdna/JS, in context of various file encodings/charsets (2010)
Help! WebCat2 bug (1997)
Sensations (1997)
Setting up the server (1997)
free zip codes database (1999)
New Command prefs ... (1997)
credit card authorization question (1997)
More on the email templates (1997)
Performance Issue (2000)
Cart questions (1997)
Setting up shop (1997)
wierd [cart] action! (1997)
F*** you (1998)
Logging purchases (1997)
Cron job for permissions (2000)