Re: lookup problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45108
interpreted = N
texte = Lookups are case-sensitive. Are the fields correct?Meaning that DB_Title, db_title, and DB_TITLE are all different fields to alookup.----- Original Message -----From: Gyuri
To: WebCatalog Talk Sent: Monday, November 11, 2002 3:47 PMSubject: lookup problem> Hi, All,>> I run into a strange problem:>> For some reason this doesn't work,>> [text]title=[lookupdb=^oo/arc/Goods.db&value=a01234&lookInField=sku&returnField=DB_Title¬Found=][/text]>>> While this does:>> [search db=^oo/arc/Goods.db&EQskuDATA=a01234&max=1]> [foundItems]> [text]title=[DB_Title][/text]> [/founditems]> [/search]>> Are these my eyes, is there any thing I don't see here?>> Thx,> Gy>> ps: it should return Desk, Plain>> --> Gyuri Ordody> Objects Online, Inc.>>>> -------------------------------------------------------------> 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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Lookups are case-sensitive. Are the fields correct?Meaning that DB_Title, db_title, and DB_TITLE are all different fields to alookup.----- Original Message -----From: Gyuri To: WebCatalog Talk Sent: Monday, November 11, 2002 3:47 PMSubject: lookup problem> Hi, All,>> I run into a strange problem:>> For some reason this doesn't work,>> [text]title=[lookupdb=^oo/arc/Goods.db&value=a01234&lookInField=sku&returnField=DB_Title¬Found=][/text]>>> While this does:>> [search db=^oo/arc/Goods.db&EQskuDATA=a01234&max=1]> [founditems]> [text]title=[DB_Title][/text]> [/founditems]> [/search]>> Are these my eyes, is there any thing I don't see here?>> Thx,> Gy>> ps: it should return Desk, Plain>> --> Gyuri Ordody> Objects Online, Inc.>>>> -------------------------------------------------------------> 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://search.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://search.smithmicro.com/
Inkblot Media
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:
Calculating multiple shipping... (1997)
Communigate+Webcat (2001)
Pop-Up Redirects (1998)
Fedora Core 3 and WebDNA (2005)
fresh eyes needed. Append won't work. (2000)
Help name our technology! (1997)
Groups doesn't work (1997)
Frames and WebCat (1997)
Setting user and password (1999)
Nested tags count question (1997)
RE:DatabaseHelper (1997)
authorize net (2001)
version history page for webcat on the SM site? (2000)
price formula (1999)
Saving Text Areas with Orders (1997)
Re[2]: Balancing randomness (2000)
Credit Card Number checking (1997)
WebCat2b15MacPlugin - [protect] (1997)
If search results are blank... (2003)
WC2.0 Memory Requirements (1997)