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.- BrianOn 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:
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.- BrianOn 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)