Re: [lookup] [search] Issue
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63066
interpreted = N
texte = 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 > digest@talk.smithmicro.com> >> 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 digest@talk.smithmicro.com> > 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/ ------------------------------------------------------------- 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:
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 > digest@talk.smithmicro.com> >> 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 digest@talk.smithmicro.com> > 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/ ------------------------------------------------------------- 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/
devaulw@onebox.com
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:
OH MY GOD! (1998)
New site announcement + Showing once on a founditems (1997)
[format xs] freeze (1997)
Purchased cart being overwritten - still !?? (1997)
Search bug. Help (2002)
Uh...can someone help me out with the b10? (1997)
Database Updates (1997)
suffix mapping for NT? (1997)
OT: WebObjects (2000)
[SEARCH] Context for SKU prices not working... (1998)
WebCat2: Found Items syntax, etc. (1997)
WebCatalog can't find database (1997)
Price override (2004)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Error with [applescript] (1999)
Code database (1998)
WebTen? (1997)
Summary search -- speed (1997)
remotely add + sign (1997)
Color (1997)