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 AM Subject: 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:

    
  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)
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 AM Subject: 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:

politeness (was searches with dash...) Please Read (2000) Writefile doesn't work, which permissions to use? (2005) [REPLACE] inside [FOUNDITEMS] (1998) Anyone here care to chime in? (2005) WebCat2b13MacPlugIn - syntax to convert date (1997) price carry over (1997) Client-side Image Maps and WebCat (what's a database-drivensite)? (1998) Multiple fields on 1 input (1997) WebCatalog2 Feature Feedback (1996) New Mac Public Beta Available (1997) Multiple Replaces? (1997) Followup question re: checksum for credit cards? (1997) Look out kiwis! (2003) WebCat2b13MacPlugIn - More limits on [include] (1997) [Reload mydata.db] (1998) [OT] help with a javascript alert (2003) Max Record length restated as maybe bug (1997) Thanks Grant (1997) PCS Frames (1997) [Announce]: Web server security and password protection (1997)