Re: close to search

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38029
interpreted = N
texte = I thought that the close to numbooks and close to 500 meant try and find a match but if you cant, dont go more than 500 but i have since changed it to 1 and it works fine for both existing and non-existing numbers...i hate the docs.on 21/8/01 12:31 PM, Alain Russell at alain.russell@blackpepper.co.nz wrote:> Andrew, > > I think you are searching for all total_number_books_local that are within > 500 of the number in the variable (according to the description in the docs) > - also try NO_BOOKStype=number .. I always find the typ=num sporadic - the > type=number always seems to work for me even though it is not specified in > the docs. > > Alain > >> does anybody know why a search such as the following does not do what it is >> suppose to do??? >> >> [search >> db=postage.db&eqCOUNTRY_FROMdatarq=[shiptocountry]&eqCOUNTRY_TOdatarq=NAT&NO >> _BOOKStype=num&clNO_BOOKSdata=[total_number_books_local]&clNO_BOOKSdata=500& >> max=1] >> >> Instead of returning one record that most closely matches the number of >> books it returns all the records. what am i doing wrong... >> >> has anybody had any success with a close to search??? >> >> Andrew Simpson >> >> >> >> ------------------------------------------------------------- >> 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://search.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://search.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: close to search (Andrew Simpson 2001)
  2. Re: close to search (Ron Parker 2001)
  3. Re: close to search (Andrew Simpson 2001)
  4. Re: close to search (Alain Russell 2001)
  5. close to search (Andrew Simpson 2001)
I thought that the close to numbooks and close to 500 meant try and find a match but if you cant, dont go more than 500 but i have since changed it to 1 and it works fine for both existing and non-existing numbers...i hate the docs.on 21/8/01 12:31 PM, Alain Russell at alain.russell@blackpepper.co.nz wrote:> Andrew, > > I think you are searching for all total_number_books_local that are within > 500 of the number in the variable (according to the description in the docs) > - also try NO_BOOKStype=number .. I always find the typ=num sporadic - the > type=number always seems to work for me even though it is not specified in > the docs. > > Alain > >> does anybody know why a search such as the following does not do what it is >> suppose to do??? >> >> [search >> db=postage.db&eqCOUNTRY_FROMdatarq=[shiptocountry]&eqCOUNTRY_TOdatarq=NAT&NO >> _BOOKStype=num&clNO_BOOKSdata=[total_number_books_local]&clNO_BOOKSdata=500& >> max=1] >> >> Instead of returning one record that most closely matches the number of >> books it returns all the records. what am i doing wrong... >> >> has anybody had any success with a close to search??? >> >> Andrew Simpson >> >> >> >> ------------------------------------------------------------- >> 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://search.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://search.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://search.smithmicro.com/ Andrew Simpson

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:

[WebDNA] [BULK] which of these tags exist in 7.0 (2011) Need Photo Placement Suggestions (2002) snicker, snicker (1997) [WebDNA] html email.. should be a no-brainer.. but it is not parsing. (?) (2010) Slow Server (2005) HELP WITH DATES (1997) Is there a max number of fields? (1998) Re1000001: Setting up shop (1997) wierd crashes for multi-sendmails on NT (1997) Quit revisited (1997) Max Record length (1997) Emailer (1997) pdf files? (2001) WebDNA on Red Hat Enterprise Linux 4 x64 (2006) Setting up WebCatalog with Retail Pro data (1996) WebCatalog vs. Cold Fusion (1998) First postarg not taking in $Commands (1997) [SearchString] problem with [search] context (1997) remotely add + sign (1997) [LOOKUP] (1997)