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:

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)