Re: [lookup] [search] Issue

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 63091
interpreted = N
texte = Generally if a search with an "eq" comparison works and a lookup doesn't, the problem is case-sensitivity. The search will match BOB to bob, but the lookup won't. - Brian On Sep 22, 2005, at 1:54 AM, Mark Derrick wrote: > The database has no empty fields or duplicates, and if I put quotes > around [CUSTOMID] I get just one set of quotes. > If I put quotes around the [lookup], and for example the [search] line > returns 4 results, then I get four pairs of empty quotes displayed by > the [lookup] line. > > The [ListWords] is returning the correct results, and even if I enter > a variable directly into the lookup, it still refuses to find a record > in the db file. > > The odd thing, is that this used to work fine, it just stopped a while > ago - and I've been spending my time since then trying to figure out > why. > > Mark. > > > On 21 Sep 2005, at 18:33, devaulw@onebox.com wrote: > >> Is it possible you have two records with the same customid and one >> has a blank for the lookup field? Put quotes around [CUSTOMNAME] in >> the search results to see if you get one or more sets of quotes. >> Bill >> >> -----Original Message----- >> From: Mark Derrick >> Sent: Wed, 21 Sep 2005 17:50:36 +0100 >> To: "WebDNA Talk" >> Subject: Re: [lookup] [search] Issue >> >> Sorry, I should have mentioned that this is within a [ListWords] >> context. >> >> I've run these two lines on the same page, and the data is only >> returned by the [search] line. >> >> Mark. >> >> >> On 21 Sep 2005, at 15:50, nitai@computeroil.com wrote: >> >> >>> Change the [word] to something else. This looks to me like a >>> reserved word for WebDNA. >>> >>> Nitai >>> >>> -- >>> >>> >>> >>>> -----Original Message----- >>>> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On >>>> Behalf Of >>>> Mark Derrick >>>> Sent: Mittwoch, 21. September 2005 16:45 >>>> To: WebDNA Talk >>>> Subject: [lookup] [search] Issue >>>> >>>> I've been staring at this for too long now, and can't see the wood >>>> for the trees. >>>> Can anyone see why the [search] works, but the [lookup] doesn't? >>>> >>>> [LOOKUP db=^databases/customnames.db&value=[word] >>>> &lookInField=CUSTOMID&returnField=CUSTOMNAME] >>>> >>>> [search db=^databases/customnames.db&eqCUSTOMIDdatarq=[word]] >>>> [founditems][CUSTOMNAME][/founditems][/search] >>>> >>>> Thanks. ------------------------------------------------------------- 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: [lookup] [search] Issue ( "Kenneth Grome" 2005)
  2. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  3. Re: [lookup] [search] Issue ( Brian Fries 2005)
  4. Re: [lookup] [search] Issue ( "Kenneth Grome" 2005)
  5. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  6. Re: [lookup] [search] Issue ( devaulw@onebox.com 2005)
  7. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  8. Re: [lookup] [search] Issue ( Donovan Brooke 2005)
  9. Re: [lookup] [search] Issue ( nitai@computeroil.com 2005)
  10. [lookup] [search] Issue ( Mark Derrick 2005)
Generally if a search with an "eq" comparison works and a lookup doesn't, the problem is case-sensitivity. The search will match BOB to bob, but the lookup won't. - Brian On Sep 22, 2005, at 1:54 AM, Mark Derrick wrote: > The database has no empty fields or duplicates, and if I put quotes > around [CUSTOMID] I get just one set of quotes. > If I put quotes around the [lookup], and for example the [search] line > returns 4 results, then I get four pairs of empty quotes displayed by > the [lookup] line. > > The [listwords] is returning the correct results, and even if I enter > a variable directly into the lookup, it still refuses to find a record > in the db file. > > The odd thing, is that this used to work fine, it just stopped a while > ago - and I've been spending my time since then trying to figure out > why. > > Mark. > > > On 21 Sep 2005, at 18:33, devaulw@onebox.com wrote: > >> Is it possible you have two records with the same customid and one >> has a blank for the lookup field? Put quotes around [CUSTOMNAME] in >> the search results to see if you get one or more sets of quotes. >> Bill >> >> -----Original Message----- >> From: Mark Derrick >> Sent: Wed, 21 Sep 2005 17:50:36 +0100 >> To: "WebDNA Talk" >> Subject: Re: [lookup] [search] Issue >> >> Sorry, I should have mentioned that this is within a [listwords] >> context. >> >> I've run these two lines on the same page, and the data is only >> returned by the [search] line. >> >> Mark. >> >> >> On 21 Sep 2005, at 15:50, nitai@computeroil.com wrote: >> >> >>> Change the [word] to something else. This looks to me like a >>> reserved word for WebDNA. >>> >>> Nitai >>> >>> -- >>> >>> >>> >>>> -----Original Message----- >>>> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On >>>> Behalf Of >>>> Mark Derrick >>>> Sent: Mittwoch, 21. September 2005 16:45 >>>> To: WebDNA Talk >>>> Subject: [lookup] [search] Issue >>>> >>>> I've been staring at this for too long now, and can't see the wood >>>> for the trees. >>>> Can anyone see why the [search] works, but the [lookup] doesn't? >>>> >>>> [LOOKUP db=^databases/customnames.db&value=[word] >>>> &lookInField=CUSTOMID&returnField=CUSTOMNAME] >>>> >>>> [search db=^databases/customnames.db&eqCUSTOMIDdatarq=[word]] >>>> [founditems][CUSTOMNAME][/founditems][/search] >>>> >>>> Thanks. ------------------------------------------------------------- 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/ Brian Fries

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:

Shopping Cart variation... (1997) denied access (1997) Date Format not working (2004) Running 2 two WebCatalog.acgi's (1996) Searching multiple fields (1997) Add - optional parameters textA=.... (1997) Need relative path explanation (1997) FlushDatabases (2000) TCPConnect and AuthorizeNet (2001) WebCatalog and WebMerchant reviewed by InfoWorld (1997) incrementing a counter remotely? (1999) are we ready to fix random sort? - Or did that already happen? (2000) Searching multiple Databases (1997) quitting (1997) Webcatalog Future?!? (2000) [WebDNA] max in a search (2009) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) [WebDNA] Ubuntu 14.04 & WebDNA (2017) Not reading code (1997) WebMerchant 1.6 and SHTML (1997)