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:
Search/sort in URL Was: GuestBook example (1997)
2.1.1 bug (ORDERFILE/SHOWIF/LINEITEMS) (1998)
Frames and WebCat (1997)
Selective Searching (2000)
[createfolder] & [deletefolder] (1997)
Any problems with Welcome & WebCat? (2000)
Bug Report, maybe (1997)
Bannerad Demo (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
japanese characters (1997)
LOG IN LOG OUT (1997)
Cookie still not working (1999)
Netscape v. IE (1997)
Showif date range comparison (1999)
Multiple catalog databases and showcart (1997)
Cart Transfer from Un-Secure to Secure (2000)
Where is eudora plugin? (1998)
talk list (2000)
Bug Report, maybe (1997)
required fields (1998)