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:
acgi to plugin migration problems (2000)
WebMerchant and Mac Auth Hub Help Please (1999)
Emailer error codes (1999)
CGI Request Time Out (1997)
syntax question, not in online refernce (1997)
Re2: Calculating multiple shipping... (1997)
executive server side java within webDNA (1997)
Getting Total Quantity (1997)
Setting up shop (1997)
autosensing lanague selection (1997)
WebCat for mass emailings (1997)
Special delete ... (1997)
emailer (1997)
Rhapsody? (1997)
Missing contexts on NT (1997)
problems with 2 tags (1997)
Shareware widget (2003)
[append] vs. [appendfile] delta + question? (1997)
WebCatalog Mac 2.1b3 (1997)
WC2b12: Yes, Formulas.db is for real (1997)