Re: Search Philosophy

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39371
interpreted = N
texte = how would this be done??? 1)add field to the db [or are you talking a different .db?] 2)[replace] the value of the uppercase field with the converted contents of original field??? 3)[lookup] to the uppercase field.how would you not look for spaces? just convert the original field contents to no spaces in the uppercase field?lastly, what is TMTOWTDI?? ;-) DJohn Peacock wrote:> Donovan Brooke wrote: > > > > Thanks to those that replied. > > I wish I could use lookup as I would like to keep this as fast as possible > > but the variables are being entered by the user so I think the case sensitivity > > will kill this. Also, I can't really [lowercase] or [uppercase] the value because > > the fields will contain mixed. :-( > > In the spirit of TMTOWTDI, you can create a search field that is an > uppercase combination of one (or more) field(s) that is used for search > purposes only and the proper case field is used for display. That would > allow you to use [lookup] for speed, as well as being able to decide > what words you want to be searchable (i.e. remove the a, etc). > > HINT: try to search for a single space some time and you'll see why > a keywords field can be VERY useful. > > JOhn > >-- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics I know I'm making progress when I look at the questions I have asked in the past and think to myself... how stupid was that ------------------------------------------------------------- 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: Search Philosophy (John Peacock 2001)
  2. Re: Search Philosophy (Donovan Brooke 2001)
  3. Re: Search Philosophy (John Peacock 2001)
  4. Re: Search Philosophy (Donovan Brooke 2001)
  5. Re: Search Philosophy (John Peacock 2001)
  6. Re: Search Philosophy (Samuel Renkert 2001)
  7. Re: Search Philosophy (Will Starck 2001)
  8. Search Philosophy (Donovan Brooke 2001)
how would this be done??? 1)add field to the db [or are you talking a different .db?] 2)[replace] the value of the uppercase field with the converted contents of original field??? 3)[lookup] to the uppercase field.how would you not look for spaces? just convert the original field contents to no spaces in the uppercase field?lastly, what is TMTOWTDI?? ;-) DJohn Peacock wrote:> Donovan Brooke wrote: > > > > Thanks to those that replied. > > I wish I could use lookup as I would like to keep this as fast as possible > > but the variables are being entered by the user so I think the case sensitivity > > will kill this. Also, I can't really [lowercase] or [uppercase] the value because > > the fields will contain mixed. :-( > > In the spirit of TMTOWTDI, you can create a search field that is an > uppercase combination of one (or more) field(s) that is used for search > purposes only and the proper case field is used for display. That would > allow you to use [lookup] for speed, as well as being able to decide > what words you want to be searchable (i.e. remove the a, etc). > > HINT: try to search for a single space some time and you'll see why > a keywords field can be VERY useful. > > JOhn > >-- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics I know I'm making progress when I look at the questions I have asked in the past and think to myself... how stupid was that ------------------------------------------------------------- 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/ Donovan Brooke

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:

emailer (1997) [WriteFile] problems (1997) WCS Newbie question (1997) Resume Catalog ? (1997) Public beta 5 of WebCatalog 4.0 is now available (2000) OT - Dig Sigs (2004) PCS Emailer's role ? (1997) emails sent twice (2001) Nested vs conditional (1997) RE: protect tag on NT (1997) [OT] Google Info (2004) Multiple SSL Keys (1998) Nav. 4 probs with cart - Serious problem (1997) Who is doing sign-ups (1998) Is there a way to just get to the last record in the database? (1997) SAVECART (1997) Emailer connect failure definitions (2003) Merging databases (1997) unable to launch acgi in WebCat (1997) Robert Minor duplicate mail (1997)