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 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  2. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  3. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  4. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  5. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  6. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  7. Re: Help with searching dates from mysql dump & searching ( Grant Hulbert 2006)
  8. Help with searching dates from mysql dump & searching between ( "Olin Lagon" 2006)
  9. Re: Help with Search ( Tom Brent 2004)
  10. Re: Help with Search ( "Jesse Crofoot" 2004)
  11. Help with Search ( "Jesse Crofoot" 2004)
  12. Re: Need help with search title (Terry Wilson 1998)
  13. Re: Need help with search title (Kenneth Grome 1998)
  14. Need help with search title (Terry Wilson 1998)
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/ "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)