Re: lookup limitation ?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 51203
interpreted = N
texte = A major difference between lookup and search is that lookup is case sensitive. Is it possible that's the problem?Regards, Tim> From: laurent pladys > Reply-To: (WebDNA Talk) > Date: Fri, 2003/06/20 14:06:27 +0200 > To: (WebDNA Talk) > Subject: lookup limitation ? > > Hi, > Does anyone knows if there is something wrong with long values in lookup > contexts ? > > With : > [lookup db=../bases/traductions.db&lookinfield=sku&value=[lng]- > [thispage]-titre&returnfield=textetraduit¬found=???] > the answer is : ??? when value= fr-pages-boutiquehome.c-lvl-titre > > In a search it works ! ([lng]-[thispage]-titre has a real value of fr- > pages-boutiquehome.c-lvl-titre > > [search db=../bases/traductions.db&eqskudatarq=[lng]-[thispage]-titre] > [founditems] > [convertchars][textetraduit][/convertchars] > [/founditems] > [/search] > > What's wrong with the lookup ? Is there a limit on a the sizre of the > comparison ? > There is going to be a performance hit if I need to use search instead of > of lookup I guess. > > Laurent > > > ------------------------------------------------------------- > 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(2): lookup limitation ? (laurent pladys 2003)
  2. Re: lookup limitation ? (Tim Robinson 2003)
  3. lookup limitation ? (laurent pladys 2003)
A major difference between lookup and search is that lookup is case sensitive. Is it possible that's the problem?Regards, Tim> From: laurent pladys > Reply-To: (WebDNA Talk) > Date: Fri, 2003/06/20 14:06:27 +0200 > To: (WebDNA Talk) > Subject: lookup limitation ? > > Hi, > Does anyone knows if there is something wrong with long values in lookup > contexts ? > > With : > [lookup db=../bases/traductions.db&lookinfield=sku&value=[lng]- > [thispage]-titre&returnfield=textetraduit¬found=???] > the answer is : ??? when value= fr-pages-boutiquehome.c-lvl-titre > > In a search it works ! ([lng]-[thispage]-titre has a real value of fr- > pages-boutiquehome.c-lvl-titre > > [search db=../bases/traductions.db&eqskudatarq=[lng]-[thispage]-titre] > [founditems] > [convertchars][textetraduit][/convertchars] > [/founditems] > [/search] > > What's wrong with the lookup ? Is there a limit on a the sizre of the > comparison ? > There is going to be a performance hit if I need to use search instead of > of lookup I guess. > > Laurent > > > ------------------------------------------------------------- > 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/ Tim Robinson

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:

Sorting a Search... (1998) Some Questions (1997) Questions about maximum (1999) WebCatb15 Mac CGI -- [purchase] (1997) won't serve .tpl (2000) MacAuthorize order data fields WAS:How To question... (1997) My first WebCat site (2000) WebCAT 4.x Configured with ASIP 6.3 (2001) Emailer Set Up (1997) Bug Report, maybe (1997) shipcost (1997) Search or delete (or date or time) has bugs ... (1998) WebCat2: Items xx to xx shown, etc. (1997) WebCatalog f2 Installation (1997) [quantity] within formulas (1997) Not really WebCat (1997) Practice runs ? (1997) PSC recommends what date format yr 2000??? (1997) I'm new be kind (1997) Cache problem (2002)