Re: [lookup] [search] Issue
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63088
interpreted = N
texte = 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 >> 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 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/
Associated Messages, from the most recent to the oldest:
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 >> 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 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/
Mark Derrick
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:
[HIDEIF] inside [FOUNDITEM] (1997)
form posts expiring instantly... why? (2000)
Multiple Newcarts (1996)
Different Drive (2003)
contextual shownext (1998)
[lowercase] and [mixedcase] (1998)
Possible Bug 4.51 (2004)
The Depths of Credit Card Payment (2003)
emailer (1997)
Weeks starting on Mondays (1998)
inside out... how much? (2004)
Tab Charactor (1997)
Storebuilder Seems to have just died (2003)
Draft Manual, Tutorial, and more (1997)
Search probl. since change WebCatalog from 2.1.3 to 3.0 (1998)
Multiple catalog databases and showcart (1997)
Loss in form (1998)
Upgrading from version (1998)
Custom WebCat Prefs ... (1997)
Emailer Set Up (1997)