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:
America Online Issues (1998)
Sorting by date (1997)
ADMIN ACCESS (1999)
TCPConnect / Current Temperature (2004)
Bug Report, maybe (1997)
[WebDNA] WebDNA Roll Call (2013)
WebCat2: multiple currency support (1997)
[OT] Bad Cookie / Internet Option / Internet Explorer (2004)
WebMerchant MacAuthorize Hub (1999)
Help with Repost Data msg from form (1997)
[WebDNA] drop off not round off (2011)
creator code (1997)
japanese characters (1997)
WebCatalog for Postcards ? (1997)
Multiple 'Users.db' files not possible (1997)
UPS (2003)
Another search question please... (1998)
Value Lists From Filemaker Pro (1999)
multi-paragraph fields (1997)
Need some feedback, please. (2003)